Permissions being erased

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

davecoats622 - 23 Feb 2006 15:56 GMT

I have a database with a front end and backend where I have set permissions
on objects on the Group level (not user level). My general users group is
called "CRTP". All table objects in this group have "Read Design", "Read
Data", "Update Data", "Insert Data", and "Delete Data" permissions. When a
user starts using the application, they get a message that says they do not
have rights. Then when I go back into the security wizard, I find several
tables where all the permissions have been removed. Why does Access
automatically remove permissions after I've already assigned them? Is there
some kind of dependency to another object which causes them to be erased?

Reply to this Message

Joan Wild - 23 Feb 2006 17:03 GMT

Where are you setting the permissions? i.e. Check in both the frontend and
the backend.

I generally don't give users any permissions on tables, but instead use RWOP
(run with owner permissions) queries for all data interaction.

Signature

Joan Wild
Microsoft Access MVP

> I have a database with a front end and backend where I have set
> permissions on objects on the Group level (not user level). My
[quoted text clipped - 7 lines]
> Is there some kind of dependency to another object which causes them
> to be erased?

Reply to this Message