Re: Do Table Permissions Override Query permissions?

Yes, they will be stopped by the permissions set on the tables. The exception would be if any of those queries are set to RWOP (run with owner permissions). In this case, their permissions on the backend tables won't matter, it's the query owner's permissions on the underlying tables that determine what will happen.

Tread carefully.

--
Joan Wild
Microsoft Access MVP
<lizo.consulting@xxxxxxxxx> wrote in message news:1193090355.058823.306500@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hi,

I administer a database in which the permissions have been "messed up"
by another administrator. I need to reset the permissions for all
objects in the database, but there are so many user created queries
this is a daunting task.

The user group level permissions have been properly applied to the
backend tables, but there are so many user created queries that
reassigning permissions on these objects is a daunting task.

If I give all user groups read/write/edit/delete access to all
queries, will the permissions set on the tables in the back-end
override the queries (and keep users out of data they shouldn't be
in?)

thanks so much for assistance!

.

Relevant Pages

  • Re: User has group permissions to object, but still denied access.
    ... permissions to those query objects. ... The owners for the other 68 queries can be changed. ... may have been some of the original queries created in the database. ... Regarding the security, the database was converted from an Access 97 ...
    (microsoft.public.access.security)
  • Re: User has group permissions to object, but still denied access.
    ... specific queries is identical to queries that she does have the ability to ... permissions depending on where the file is, it means she's either opening the ... about 80 queries in the database, and I haven't been able to find a pattern ... The Admins group was given full permissions. ...
    (microsoft.public.access.security)
  • Re: Probs accessing database for users of newly developed Superuse
    ... database from a shortcut on their desktop. ... This group is to have virtually all permissions except administer. ... I get the error message “You do not have ...
    (microsoft.public.access.security)
  • Re: no read definitions on query
    ... If queries, then the users need at least read data permissions in order to ... If you had no permissions on the queries/tables, ... level security on a database. ... not the user tried to access the query. ...
    (microsoft.public.access.security)
  • Re: RWOP /table permissions question
    ... With Admins permissions, yes they can. ... Microsoft Access MVP ... I have the database window hidden on the ... Now base all your SQL statements on these queries rather than the ...
    (microsoft.public.access.security)