CONTROL

This box indicates whether the user referenced on the Database page has the CONTROL privilege on indexes selected in the Index column. To change the box's setting, click on the down arrow and select the setting that you want. You can select:

Yes

Grants the CONTROL privilege without the Grant option (the right to grant the CONTROL privilege on the selected index or indexes to other users).

No

Initially means that the user referenced on the Database page doesn't have the CONTROL privilege on the selected index or indexes. To cancel a request for the CONTROL privilege on an index, select the index and change the setting from Yes to No.

The CONTROL privilege on an index allows a user to drop the index. Unless the user has SYSADM or DBADM authority, he or she cannot grant this privilege to other users or to groups.

If you select multiple indexes for which you specified different settings (for example, Yes for one index andNo for the others), the CONTROL box is blank. But the settings that you specified remain in effect.

[ Top of Page | Table of Contents | Glossary | Index ]

[ DB2 List of Books | Search the DB2 Books ]