Permissions in Access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have 3 workgroups on my database including a read only and anotherone that
has users with permissions to read, write and update certain tables only.
These have been able to write in table that they are not supposed to, how do
i sort that out?
 
These have been able to write in table that they are not supposed to, how
do
i sort that out?
Click to expand...

Go into Tools, Security, User and Group Permissions. (logged on so you are
able to)

Select the table you are worried about, under "Object Type" and "Object Name".

Now, in sequence, select the User and the Groups the user is assigned to. For
each selection, the permissions is shown. One of them allows permissions.

To find out what groups the user is assigned to, Tools, Security, User and
Group Accounts.

There's a lot of options and permissions for sure. Yet the concept is simple.
A User is assigned to certain Groups. Both the User and the Groups can have
permissions on the table (or other object). This is separate for each table
(or object).

Permissions are cumulative to allowing permission. They only need permission
in one place (say a Group they belong to), to have those permissions. You have
to check each and every table/object, for each and every User and Group.
That's a lot of checking. It's also why it's so powerful.

Chris
 
Back
Top