SQL Reference

SYSCAT.INDEXAUTH

Contains a row for every privilege held on an index.

Table 64. SYSCAT.INDEXAUTH Catalog View
Column Name Data Type Nullable Description
GRANTOR VARCHAR(128)
Authorization ID of the user who granted the privileges.
GRANTEE VARCHAR(128)
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 VARCHAR(128)
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.


[ Top of Page | Previous Page | Next Page ]