Changing table privileges

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

Fields and controls

Authorities and privileges

To change a user's privileges on tables:

1. Open the Change User notebook.

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

3. Perform one or more of the following operations:

   • Operations involving tables 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 tables 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
   • 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