Granting the CONTROL privilege on indexes to a new user

Use the Index page of the Add User notebook to grant the CONTROL privilege on a database's indexes to a new user of this database.

Fields and controls

Authorities and privileges

To grant the CONTROL privilege on indexes:

1. Open the Add User notebook.

2. Open to the Index page by clicking on the page's tab.

3. List the indexes on which you want to grant the CONTROL privilege.

4. In the Index column, select one or more indexes.

5. Request the CONTROL privilege by either:

   • Clicking on Grant All. The CONTROL box specifiesYes.

   • Using the CONTROL box to specify Yes.

   When you click on Grant All or specify Yes, the Xs next to the selected indexes are replaced by check marks framed by corner brackets. The brackets indicate that your grants are pending.

6. If you didn't specify the authorization name of the person to whom you're granting index privileges, you must:

   1. Open to the Database page by clicking on the page's tab.

   2. Use the User box to specify the authorization name.

7. Click on Apply. The privileges are granted. As a sign of this, the brackets disappear, leaving the check marks unframed.

8. Optional: Grant one or more of the following types of authorizations, in any order:
   • Database authorities
   • Schema privileges
   • Table privileges
   • View privileges

9. Click on Cancel to close the Add User notebook.

Related information

• Add User -- Overview
• Controlling database access -- See the Administration Guide
• GRANT and REVOKE statements -- See the SQL Reference
• Authorizations and authorization names for users and groups