Granting table privileges to a new user

Use the Table page of the Add User notebook to grant privileges on tables in a database to a new user of this database.

Fields and controls

Authorities and privileges

To grant table privileges:

1. Open the Add User notebook.
2. Open to the Table page by clicking on the page's tab.
3. List the tables that you want to grant privileges on.
4. Specify the privileges that you want to grant. You can grant all privileges and the Grant option at the same time, or you can grant privileges individually.
5. If you didn't specify the authorization name of the user to whom you're granting table privileges, you must:
   1. Open to the Database page by clicking on the page's tab.
   2. Use the User box to specify the authorization name.
6. Click on Apply. The privileges are granted.
7. Optional: Grant one or more of the following types of authorizations, in any order:
   • Database authorities
   • Schema privileges
   • Index privileges
   • View privileges
8. Click on Cancel to close the Add User notebook.

Related information

• Add 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