Granting the USE privilege on table spaces

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

Fields and controls

Authorities and privileges

To grant the USE privilege on table spaces:

1. Open the Change User notebook.
2. Open the Table Space page.
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. Use either of the following methods to grant the USE privilege:
   • Click the Grant All push button. In the USE column, check marks framed by corner brackets replace the Xs and the USE box specifies Yes. The check marks framed by corner brackets indicate that the grant of the USE privilege is pending.
   • In the USE drop down list select Yes. In the USE column, check marks framed by corner brackets replace the Xs. The check marks framed by corner brackets indicate that the grant of the USE privilege is pending.
5. Click Apply to accept the changes. The corner brackets disappear leaving the check marks unframed indicating the USE privilege has been granted
6. Optional: Grant one or more of the following types of privileges, in any order:
   • Schema privileges
   • Table privileges
   • Index privileges
   • View privileges
7. Click OK.

Related information

• Showing Commands or SQL