Listing indexes

To list indexes on which you want to grant the CONTROL privilege:

  1. Click on Add index. The Add Index window opens.

  2. Use the Schema box to specify a schema that includes indexes that on which you want to grant the CONTROL privilege. A list of the schema's indexes appears in the Index list box.

  3. Select the index or indexes that you want.

  4. Click on Apply. The selected index or indexes are listed in the Index column. In addition, Xs appear in the CONTROL column and No appears in the CONTROL box. The Xs and No mean that the group referenced on the Database page doesn't have the CONTROL privilege on the selected index or indexes.

  5. Repeat steps 2, 3, and 4 to add indexes from another schema.

  6. Click on Cancel in the Add Index window. The window closes.


Related information