Revoking the USE privilege on table spaces

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

Fields and controls

Authorities and privileges

To revoke the USE privilege on a table space:

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 for which you want to revoke the USE privilege.
4. Use either of the following methods to revoke the USE privilege:
   • Click the Revoke All push button. As a sign that the revocation is pending, an X framed by corner brackets appears in the USE column to the right of each selected table space. In the USE column, Xs framed by corner brackets replace the check marks and the USE box specifies No. The Xs framed by corner brackets indicate that the revocation of the USE privilege is pending.
   • In the USE drop down list select No. In the USE column, Xs framed by corner brackets replace the check marks and the USE box specifies No. The Xs framed by corner brackets indicate that the revocation of the USE privilege is pending.
5. Click the Apply push button to accept the changes. The corner brackets disappear leaving the Xs unframed indicating the USE privilege has been revoked.
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.