Table Space page

Table Space

Add Table Space

Grant All

Revoke All

USE

OK

Show SQL

Apply

Reset

Cancel

Table Space

This box consists of a Table Space column and a column for the USE privilege. Use this box to list and select the table spaces that you want to grant USE privileges on. To add a Table Space to the box, click the Add Table Space push button and select the tables space on the Add Table Space window.

Next to the table space names, the USE column displays symbols that indicate whether grants and revocations of the USE privilege are pending or have been made. These symbols change to reflect changes that you make when you use the USE box or the Grant All or Revoke All push buttons.

Add Table Space

Click this push button to open the Add Table Space window, to select Table Spaces that you want to grant privileges on. When you click on Apply in this window, the selected views are added to the Table Space page.

Grant All

Click this push button to grant the USE privilege on a table space.

Revoke All

Click this push button to revoke the USE privilege on a table space.

USE

This box displays a setting that indicates whether the group has the USE privilege on table spaces selected in the Table Space column. To change the setting, click the down arrow and select a setting. You can select Yes or Grant to grant the USE privilege, or No to revoke the USE privilege.