Re: Network Folder Permissions



=?Utf-8?B?Q2hyeXN0YWw=?= <Chrystal@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote
in news:17FB31BF-6E53-41FF-860D-A95006E1777D@xxxxxxxxxxxxx:

I have an access database on a shared network folder. This
database is used by mulitple users with full access to the shared
folder on the network. We have a new user that only has read
rights on the shared folder. Can I create a local database with
linked tables to the shared database for this individual without
changing his shared folder permissions?

It's not at all clear to me what you want.

The user in question is in a group that has read-only rights. That
will mean any files in the share will be read-only. If that's what
you want, then I just don't see what your question is.

To manage groups of users who need different rights on a share, you
create different user groups with different permissions provided for
the shares. It's better to create custom groups than it is to use
built-in groups (like users), because that gives you finer control
over who is a member (and still makes it possible to add large
groups of users in one fell swoop by simply adding their user group
as a member).

If, for instance, your Authenticated Users group has full
permission, but you want some people to have read-only, then create
a new user group (say "Read-Only Users") and apply DENY permission
to the folder for that user group on the create/modify/etc.
permissions. That will allow you to deny write to someone who is a
member of a default group and can't be removed (or who needs to be
in that group for other purposes). Remember, DENY permissions
override all other permissions (exactly the opposite of Jet
user-level security, BTW).

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
.



Relevant Pages

  • Re: Have database mismatch, can I move NTDS.dit and Exchange to new identical server?
    ... Check the physical location of the Winnt\NTDS\ folder. ... Check the permissions on the \Winnt\NTDS folder. ... as it may not be the database that is the ... MCSA + Exchange ...
    (microsoft.public.win2000.active_directory)
  • Re: Help - locked out of database
    ... IT checked all the permissions and everything seems to be ok. ... "Joan Wild" wrote: ... I have poured a year into this database - is there someway to recover this? ... You need, at minimum, modify permission on the folder. ...
    (microsoft.public.access.security)
  • Re: db_denydatawriter
    ... perhaps this also gives read write access on the database to this user? ... Resrictive permissions overrides in its own level. ... However, if she has sysadmin right, then she'll be able to modify that data. ... Is it possible she has some admin rights which override DenyWriter (though ...
    (microsoft.public.sqlserver.security)
  • Re: Issue: LDB Not Being Created
    ... I would totally agree that it is a rights issue (and was convinced it ... I open the database and the LDB gets created. ... file create permissions, then all other users of the network would be able ... However if one user opens up the file does not have correct permissions to ...
    (comp.databases.ms-access)
  • Re: Shared v. Exclusive Access
    ... The folder wherein the frontend resides grants Full permissions to the ... When I open the database, however, I don't get the message boxes. ...
    (microsoft.public.access.security)

Quantcast