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 Table Spaces to the box, click the Add Table Space push button and select them on the Add Table Space window.

Next to the table space names, this box 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 boxes or the Grant All or Revoke All push buttons.

Add Table Space

Click this push button to open the Add Table Space window, so you can select Table Spaces that you want to grant privileges on. When you click on Apply in this window, the selected table spaces 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 on the down arrow and select the setting that you want. You can select Yes or Grant to grant the USE privilege on a table space, or select No to revoke the USE privilege on a table space.