Change a query's permissions (MDB)

In a security-enabled workgroup, you can change the default permissions that allow others to view data returned from queries, or, in the case of action queries, to run the queries, even if they are otherwise restricted from viewing the underlying table or query.

1. On the Tools menu, click Options.
2. Click the Tables/Queries tab.
3. Click the Run Permissions option you want to use.

   If you select Owner's:

   • All users have the query owner's permission to view or run the query.
   • Only the query owner can save changes to the query.
   • Only the query owner can change the ownership of the query.

   If you select User's, the permissions that are defined for that classification of users are in effect instead. Any user with Administer permissions for the query can save changes to the query or change its ownership.

Note  Changing the default permissions affects only new queries.

In a security-enabled workgroup, you can assign others permission to view the data your query returns or, in the case of an action query, to run the query, even if they are otherwise restricted from viewing the query's underlying table or query.

By setting the RunPermissions property of the query to Owner's, all users have the query owner's permission to view or run the query, only the query owner can save changes to the query, and only the query owner can change the ownership of the query.

Security Note    Be careful using the RunPermissions property. In effect, you are giving users restricted read access to the data underlying the query. Sensitive or confidential information could be inadvertently revealed to other users.

1. Open the query in Design view.
2. Select the query by clicking anywhere in query Design view outside the design grid and the field lists.
3. Click Properties on the toolbar to display the query's property sheet.
4. Set the RunPermissions property to Owner's.