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.

Column Name	Data Type	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 ]