Re: Query permissions

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

"RipperT @nOsPaM.nEt>" <<RiPpErT> wrote in message news:Ot0eRYMJJHA.5576@xxxxxxxxxxxxxxxxxxxxxxx
If I use WITH OWNERACCESS OPTION in the queries, then everybody can read, update, modify and delete the data.

If you use RWOP queries then *you* set the permissions for users on them as if they were the tables. With RWOP queries other groups do not inherit the db owner's permissions, on the contrary, by default they have *no* permissions, you have to set them. If your users have full permissions to your RWOP queries and you haven't set them then you may not have set up ULS properly (and it is easy to miss a step).

Regards,
Keith.
www.keithwilby.com

.

Relevant Pages

  • Re: limiting table access and RWOP queries
    ... The table tblLocalCompanyCityLookup has no permissions for members of the ... So it seems like the code query runs with user permissions to me. ... > tables, then, using rwop queries is the way to go. ... in a turnkey database application. ...
    (microsoft.public.access.security)
  • Re: Relink question
    ... I have full permissions for all users on the BE tables, and table permissions restricted in the FE depending on the group. ... It would help if I knew whether the destination database is the link's destination or if "destination" means something else. ... Anyhow, I have not found a need for RWOP queries, so I think I'm OK with RefreshLink. ... so Access won't let me implicitly declare. ...
    (microsoft.public.access.formscoding)
  • Re: limiting table access and RWOP queries
    ... > I'm securing my first mulit-user database, and I'm thinking of giving users ... RWOP queries hide details of the table design, ... and it seems I can't give those owner permissions. ...
    (microsoft.public.access.security)
  • Re: Query permissions
    ... Have you ensured that the Users group does not have any permissions to anything? ... Your custom users group has read permissions on all the RWOP queries. ... I want one user to be able to read, update, modify and delete data in these forms. ...
    (microsoft.public.access.security)
  • Re: Relink question
    ... Note that allowing all permissions on the linked tables in the frontend does ... Since I do not have RWOP queries I think I can use RefreshLink. ... tables in the destination database. ... so Access won't let me implicitly declare. ...
    (microsoft.public.access.formscoding)