Granting and revoking the USE privilege on table spaces

Use the Table Space page of the Change User notebook to grant or revoke the USE privilege on table spaces.

Fields and controls

Authorities and privileges

To grant or revoke the USE privilege on table spaces:

1. Open the Change User notebook.
2. Open the table space page.
3. Perform one or both of the following operations:
   • Grant the USE privilege on table spaces.
   • Revoke the USE privilege on table spaces.
4. Optional: Grant and revoke one or more of the following kinds of authorizations, in any order:
   • Database authorities
   • Schema privileges
   • Table 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