Change default permissions for all new queries

This content is no longer actively maintained. It is provided as is, for anyone who may still be using these technologies, with no warranties or claims of accuracy with regard to the most recent product version or service release.

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. Changing the default permissions affects only new queries.

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, and any user with Administer permissions for the query can save changes to the query, or change its ownership.