CONTROL

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

Yes

Grants the CONTROL privilege.

No

Initially means that the group 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 or Grant to No.

Grant

Grants the CONTROL privilege with the Grant option.

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 and 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 ]