Re: User permissions dropping out

Back up a bit. I don't see why the user needs 'modify table design' to run an update table query. An Update Query updates *data* in the table, not the design of a table. So therefore the user needs only update permission on the table. You could achieve this by removing all permissions on the tables for the Read-only user and making the Update Query 'RWOP' (a setting in the properties of the query. This means Run With Owner Permissions, and will allow the user to update the table. You then just give them udpate permission on this saved RWOP query.

More at www.jmwild.com/RWOP.htm



Joan Wild
MS Access MVP


Barry wrote:
OK, I figured out the security problem...what I had to do is set all permissions, but 'Administer' for the table to be updated each time the db is opened, for the read-only user. In addition, had to set the same permissions for <New Tables/Queries> and a linked table from which the make-table query pulls data from. I think I will be able to adjust the permission settings more once the db is split.

"Barry" wrote:

I have done everything perceivably correct to set up security on a database, and am testing a "Read Only" user test subject. I must set the permissions to 'modify table design' for a particular table that is updated when the db is opened, thru the 'Autoexec' macro (run on an update-table query). Logged in as Administrator, I set the permission, then exit and login as the Read Only user OK, until after logging in again, following logging in as Administrator again. It seems to drop this permission for some reason. I have the db and workgroup file located in a folder on my desktop. I don't imagine it is due to IT permissions to the C: drive, since I can create the files in the first place on my desktop.
.

Relevant Pages

  • Re: restricted user level security
    ... All of my queries and macros are built off the Supervisor name, ... query, the query includes all of the fields and the CurrentUsercriteria. ... I changed the Run Permissions to Owner. ... you can set up user level security. ...
    (microsoft.public.access.security)
  • Re: Object permissions
    ... Who is the owner of the query? ... permissions does the owner have on the underlying tables? ... does the user have on the query; ... to 'owners' in the sql statement each time the code runs, ...
    (microsoft.public.access.security)
  • Query permissions
    ... I want all users to have read permissions to the data in these forms. ... tables and given Read permissions to my custom users group for each query. ... I've given read, update, modify and delete permissions on each query to the ... group called HugosGroup, and Hugo is the only member of that group (except ...
    (microsoft.public.access.security)
  • Re: Query permissions
    ... Copy the sql from each query for the form and subforms and put the sql in the ... Now Hugo and the Admins group can read, edit, add and delete records in the ... I want all users to have read permissions to the data in these forms. ... I've given read, update, modify and delete permissions on each query to the ...
    (microsoft.public.access.security)
  • Re: Advance Security Issue Part II
    ... >> Okay, I've got the dual-mdw thing all straight, now I have a permissions ... >> created a Snapshot query to read that table. ... > because the effects of the WITH OWNER ACCESS ... > does not exist in the current workgroup file. ...
    (microsoft.public.access.security)
Loading