Granting and revoking the USE privilege on table spaces

Use the table space page of the Change Group 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 Group notebook.
2. Open to 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 Group notebook.

Related information

• Change Group -- Overview
• Controlling database access -- See the Administration Guide
• GRANT and REVOKE statements -- See the SQL Reference
• Authorizations and authorization names for users and groups