Latest LQ Deal: Linux Power User Bundle
Go Back > Forums > Linux Forums > Linux - Newbie
User Name
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!


  Search this Thread
Old 12-04-2004, 07:13 PM   #1
LQ Newbie
Registered: Jul 2004
Posts: 22

Rep: Reputation: 15
Another "special directory access" question

(Linux RedHat 9 Enterprise, with Windows 2000/XP workstations...)

Our client has an access database "MH" that we wish to isolate and treat as an "application" . To do so, this is my plan:

Create an "/home/MHDB" directory, make it a SAMBA share

Create a Linux user group called "MHDBUsers"

chown the MHDB directory as "root:MHDBUsers"

Place the access database file(s) in the "MHDB" directory

My question is, what kind of SAMBA or Linux file permissions can I set on the MHDB directory that would prevent users from being able to place just any file they want in that directory, or deleting the database file(s) that will be used there? Is that simply impossible? Do they need full 770 permissions to the directory in order to open and use the access database?

The goal is twofold:

1. To keep the directory as "clean" as possible... by not allowing users to put other files there other than what's already been placed there by me. If they browse the server, and can get into that folder, they should only be able to "run" the database file... not put new files in there or delete what's there. (I assume that there will be a need to allow creation of the ".ldb" files that MS uses to "lock" the DB, so I'm not sure quite how this would work.)

2. To allow only specified users to run the database, without using permissions within the database application (MSAccess) itself.

Looking for some "best practice" advice... treat the MSAccess db as you might consider any other "shared application", and let me know what YOU might do!

Thanks once again. These forum are an incredibly valuable resource, and everyone that's ever responded to my questions has been SUPER. You are all very much appreciated!

Old 12-04-2004, 08:31 PM   #2
Senior Member
Registered: Nov 2004
Location: Third rock from the Sun
Distribution: NetBSD-2, FreeBSD-5.4, OpenBSD-3.[67], RHEL[34], OSX 10.4.1
Posts: 1,197

Rep: Reputation: 46
chown -R root:MHDBUsers /home/MHDB/
chmod 750 /home/MHDB
chmod 660 /home/MHDB/blah.mdb

Put your users in MHDBUsers like you said. The one hangup here is that this will let the users change the mdb file, but will not let them create the lock files you mention. It will prevent them from creating new files in there too though.


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
"proftpftd.conf" limiting read access in uploads directory for non ftpadmin maxut Linux - Networking 0 09-04-2004 07:25 AM
"X-MS" cant open because "x-Multimedia System" cant access files at "smb&qu ponchy5 Linux - Networking 0 03-29-2004 11:18 PM
"No write access to $HOME directory" Arthaus Linux - Newbie 2 01-12-2004 07:22 PM
need help, on how to access quickly to special characters like "" or ""? Motaro Linux - Newbie 1 12-31-2003 11:53 AM
Can't access mounted NFS directory: "permission denied" SparceMatrix Linux - General 6 03-08-2003 01:36 PM > Forums > Linux Forums > Linux - Newbie

All times are GMT -5. The time now is 08:29 PM.

Main Menu
Write for LQ is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration