How to Secure the folder

[nancye]

I have a database with user lever security with a groups with Read Only
permissions and a group with Admin persmissions
..
Everyone in our office has network rights: Modify, Read, Write, Read &
Execute, and List Folder contents to the network folder where the database is
located.

How can I secure the folder so the database is not deleted or renamed or the
folder isn't deleted or renamed.

 

[Keith Wilby]

I have a database with user lever security with a groups with Read Only
permissions and a group with Admin persmissions
.
Everyone in our office has network rights: Modify, Read, Write, Read &
Execute, and List Folder contents to the network folder where the database
is
located.

How can I secure the folder so the database is not deleted or renamed or
the
folder isn't deleted or renamed.

Here's one way:

http://www.ss64.com/nt/cacls.html

Keith.
www.keithwilby.co.uk

 

[nancye]

But if a user must have read/write/delete to the folder where the database
resides, then there is no way to prevent them from deleting the database file
or renaming it, correct?

 

[Douglas J. Steele]

It's possible to have Delete permissions on the Folder (so that
newly-created files inherit the permission), but not have Delete permission
on a specific file in the folder (although if you do this, recognize that
someone will have to have Delete in order to be able to compact the file)