Contains a row for every privilege held on an index.
Table 49. SYSCAT.INDEXAUTH Catalog View
| Column Name | Data Type | Nullable | Description |
|---|---|---|---|
| GRANTOR | CHAR(8) |
| Authorization ID of the user who granted the privileges. |
| GRANTEE | CHAR(8) |
| Authorization ID of the user or group who holds the privileges. |
| GRANTEETYPE | CHAR(1) |
|
U=Grantee is an individual user G=Grantee is a group |
| INDSCHEMA | CHAR(8) |
| Name of the index. |
| INDNAME | VARCHAR(18) |
| |
| CONTROLAUTH | CHAR(1) |
| Whether grantee holds CONTROL privilege over the index:
Y=Privilege is held N=Privilege is not held |