Changing view privileges

Use the View page of the Change User notebook to change a user's privileges on views.

Fields and controls

Authorities and privileges

To change a user's privileges on views:

1. Open the Change User notebook.

2. Open to the View page by clicking on the page's tab.

3. Perform one or more of the following operations:

   • Operations involving views on which the user has one or more privileges:

     • Grant all additional privileges at the same time.

     • Grant additional privileges or change Grant options individually.

     • Revoke all privileges at the same time.

     • Revoke privileges individually.

   • Operations involving views that the user has no privileges on:

     • Grant all privileges at the same time.

     • Grant privileges individually.

4. Optional: Grant and revoke one or more of the following kinds of authorizations, in any order:
   • Database authorities
   • Schema privileges
   • Table privileges
   • Index privileges

5. Click on Cancel to close the Change User notebook.

Related information

• Change User -- Overview
• Controlling database access -- See the Administration Guide
• GRANT and REVOKE statements -- See the SQL Reference
• Authorizations and authorization names for users and groups