SYSCAT.INDEXAUTH catalog view

Each row represents a user, group, or role that has been granted CONTROL privilege on an index.

Table 1. SYSCAT.INDEXAUTH Catalog View
Column Name Data Type Nullable Description
GRANTOR VARCHAR (128)   Grantor of the privilege.
GRANTORTYPE CHAR (1)  
  • S = Grantor is the system
  • U = Grantor is an individual user
GRANTEE VARCHAR (128)   Holder of the privilege.
GRANTEETYPE CHAR (1)  
  • G = Grantee is a group
  • R = Grantee is a role
  • U = Grantee is an individual user
INDSCHEMA VARCHAR (128)   Schema name of the index.
INDNAME VARCHAR (128)   Unqualified name of the index.
CONTROLAUTH CHAR (1)   CONTROL privilege.
  • N = Not held
  • Y = Held