Listing indexes

To list the index or 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 any indexes that you want listed. A list of the schema's indexes appears in the Index list box.
  3. In the Index list box, select the index or indexes on which you want to grant the CONTROL privilege.
  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 user doesn't have the CONTROL privilege on the selected index or indexes.
  5. Optional: Repeat steps 2, 3, and 4 to add indexes from another schema.
  6. Click on Cancel in the Add Index window. The window closes.