| Task
| Authorities and privileges
|
| To change the comment for an index
| You must either be the definer as recorded in the DEFINER column of
SYSCAT.INDEXES, or have at least one of the following
authorities:
- SYSADM or DBADM
- CONTROL privilege on the index
- CONTROL privilege on the table that is indexed
- ALTERIN privilege on the index's schema
|
| To create an index
| You must have SYSADM or DBADM authority, or you must have both of the
following privileges and authority:
- CONTROL or INDEX privileges for the table on which the index is
created.
- IMPLICIT_SCHEMA authority on the database, if the implicit or explicit
schema name of the index does not exist, or CREATEIN privilege on the schema,
if the schema name of the index exists.
|
| To create or edit a workload
| You must have SYSADM or DBADM authority.
|
| To add or change SQL statements
| You must have SYSADM or DBADM authority.
|
| To import SQL statements
| You must have SYSADM or DBADM authority.
|
| To alter optimization algorithm parameters
| You must have SYSADM or DBADM authority.
|
| To view workload details
| You must have SYSADM or DBADM authority.
|
| To drop an index
| You must either be the definer as recorded in the DEFINER column of
SYSCAT.INDEXES, or have at least one of the following
authorities:
- SYSADM or DBADM
- CONTROL privilege on the index
- CONTROL privilege on the table that is indexed
- DROPIN privilege on the index's schema
|
| To grant or revoke the CONTROL privilege to users or user groups for the
selected index
| You must have SYSADM or DBADM authority.
|