Granting and revoking table privileges for users

Use the User page of the Table Privileges notebook to grant privileges on a selected table to users, and to revoke privileges that users hold on this table. In addition, you can provide and withdraw the Grant option (the right to grant a privilege to other users and to groups).

Fields and controls

Authorities and privileges

To grant or revoke table privileges for users:

1. Open the table Table Privileges notebook.

2. If you are not already on the User page, click on the User tab. The User page opens. The User box displays the authorization names of users that hold one or more privileges on the selected table.

3. If you plan to grant privileges on the selected table to other users, add these users to the User box.

4. Manage privileges by performing one or more of the following actions:
   • Grant all privileges; provide the Grant option.
   • Revoke all privileges.
   • Manage privileges individually.

5. Optional: Grant privileges on the selected table to groups, or revoke groups' privileges on this table.

6. Click on Cancel to close the Table Privileges notebook.

Related information

• Table Privileges -- Overview
• Controlling database access -- See the Administration Guide
• GRANT and REVOKE statements -- See the SQL Reference
• Authorizations and authorization names for users and groups
• Showing Commands or SQL