Granting the USE privilege on table spaces to a new user

Use the Table Space page of the Add User notebook to grant the USE privilege on table spaces to a new user of this database.

Fields and controls

Authorities and privileges

To grant the USE privilege on table spaces to a new user:

1. Open the Add User notebook.
2. Open to the Table Space page by clicking on the page's tab.
3. From the list of table spaces in the Table Space box, select the table space to which you want to grant the USE privilege.
4. In the table spaces column, select one or more table spaces.
5. Request the USE privilege by either:
   • Clicking on the Grant All push button. The USE box specifies Yes.
   • Using the USE box to specify Yes. When you click on Grant All or specify Yes, the Xs next to the selected table spaces are replaced by check marks framed by corner brackets. The brackets indicate that your grants are pending.
6. If you didn't specify the authorization name of the person to whom you're granting table spaces 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.
7. Click on Apply. The privileges are granted. As a sign of this, the brackets disappear, leaving the check marks unframed.
8. Optional: Grant one or more of the following types of authorizations, in any order:
   • Database authorities
   • Schema privileges
   • Table privileges
   • View privileges
9. 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