Changing schema privileges

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

Fields and controls

Authorities and privileges

To change a user's privileges on schemas:

1. Open the Change User notebook.
2. Open to the Schema page by clicking on the page's tab.
3. Perform one or more of the following operations:
   • Operations involving schemas 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 schemas 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
   • Table privileges
   • Index privileges
   • View 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