[AccessD] Permissions Refresher

...William knows nnnooottthhhinnnggg! ...just ask JC ...he'll confirm that
:)

William Hindman
"Always code as if the person who is maintaining or testing your code is
a violent psychopath who knows where you live." William Silverstein


----- Original Message ----- 
From: "Gustav Brock" <gustav at cactus.dk>
To: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
Sent: Wednesday, April 14, 2004 1:45 PM
Subject: Re: [AccessD] Permissions Refresher


> Hi Mark
>
> > I have a database that is currently restricted (by folder permissions)
to
> > only a few individual persons.  I am now in the process of creating a
> > database for general use that needs to link to a table in that
restricted
> > database.  Out of the following permissions, what is the minimum
necessary
> > to allow a user to execute select queries, but not allow any
modifications
> > to the data?
>
> I don't think you can do this as you for the new user group would need
> to have two levels of permissions: read-only for the data file, and -
> as for the first group - create-read-write (or better:
> create-read-write-erase) for the the locking file (.ldb).
>
> This article covers your initial scenario but not your requested
> scenario, "Restrict The People Who Can Use Your Database Folder":
>
>   http://www.vb123.com/toolshed/04_docs/accessdb_op_security.htm
>
> However - as William will know - if you really need this setup, go and
> get a Novell NetWare server. Here you can control user permissions
> down to the single file; this scenario could be created in two
> minutes.
>
> /gustav
>
> -- 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>