LinuxQuestions.org
Welcome to the most active Linux Forum on the web.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
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!

Notices


Reply
  Search this Thread
Old 12-04-2004, 08:13 PM   #1
funaroma
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!

marc
 
Old 12-04-2004, 09:31 PM   #2
sigsegv
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.
 
  


Reply


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 08:25 AM
"X-MS" cant open because "x-Multimedia System" cant access files at "smb&qu ponchy5 Linux - Networking 0 03-30-2004 12:18 AM
"No write access to $HOME directory" Arthaus Linux - Newbie 2 01-12-2004 08:22 PM
need help, on how to access quickly to special characters like "" or ""? Motaro Linux - Newbie 1 12-31-2003 12:53 PM
Can't access mounted NFS directory: "permission denied" SparceMatrix Linux - General 6 03-08-2003 02:36 PM

LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie

All times are GMT -5. The time now is 11:19 AM.

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