SQL Reference

SYSCAT.COLAUTH

Contains one or more rows for each user or group who is granted a column level privilege, indicating the type of privilege and whether or not it is grantable.

Table 47. SYSCAT.COLAUTH Catalog View

Column Name	Data Type	Nullable	Description
GRANTOR	VARCHAR(128)		Authorization ID of the user who granted the privileges or SYSIBM.
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.
TABSCHEMA	VARCHAR(128)		Qualified name of the table or view.
TABNAME	VARCHAR(128)
COLNAME	VARCHAR(128)		Name of the column to which this privilege applies.
COLNO	SMALLINT		Number of this column in the table or view.
PRIVTYPE	CHAR(1)		Indicates the type of privilege held on the table or view: U = Update privilege R = Reference privilege
GRANTABLE	CHAR(1)		Indicates if the privilege is grantable. G = Grantable N = Not grantable