SYSCOLAUTH catalog table

The SYSCOLAUTH table records the UPDATE or REFERENCES privileges that are held by users on individual columns of a table or view. The schema is SYSIBM.

Column name Data type Description Use
GRANTOR
VARCHAR(128)
NOT NULL
 Authorization ID or role of the user who granted the privileges. Could also be PUBLIC. G
GRANTEE
VARCHAR(128)
NOT NULL
 Authorization ID or role of the user who holds the privilege or the name of an application plan or package that uses the privilege. PUBLIC for a grant to PUBLIC. G
GRANTEETYPE
CHAR(1)
NOT NULL
 Type of grantee:
blank
An authorization ID
L
Role
P
An application plan or a package. The grantee is a package if COLLID is not blank.
 G
CREATOR
VARCHAR(128)
NOT NULL

The schema of the table or view on which the update privilege is held.

 G
TNAME
VARCHAR(128)
NOT NULL
 Name of the table or view. G
—
CHAR(12)
NOT NULL
 Internal use only. I
DATEGRANTED
CHAR(6)
NOT NULL
 Not used. N
TIMEGRANTED
CHAR(8)
NOT NULL
 Not used. N
COLNAME
VARCHAR(128)
NOT NULL
 Name of the column to which the UPDATE privilege applies. G
IBMREQD
CHAR(1)
NOT NULL
 A value of Y indicates that the row was provided with the Db2 product code. For all other values, see Release dependency indicators.

The value in this field is not a reliable indicator of release dependencies.

 G
LOCATION
VARCHAR(128)
NOT NULL WITH
DEFAULT
 Not used. N
COLLID
VARCHAR(128)
NOT NULL WITH
DEFAULT
 If GRANTEE is a package, its collection name. Otherwise, the value is blank. G
CONTOKEN
CHAR(8)
NOT NULL
WITH DEFAULT
FOR BIT DATA
 If GRANTEE is a package, the consistency token of the DBRM from which the package was derived. Otherwise, the value is blank. S
PRIVILEGE
CHAR(1)
NOT NULL WITH
DEFAULT
 Indicates which privilege this row describes:
R
Row pertains to the REFERENCES privilege.
blank
Row pertains to the UPDATE privilege.
 G
GRANTEDTS
TIMESTAMP
NOT NULL WITH
DEFAULT
 Time when the GRANT statement was executed. G
GRANTORTYPE
CHAR(1)
NOT NULL WITH
DEFAULT
 Indicates the type of grantor:
L
Role
blank
Authorization ID that is not a role
 G
Start of changeSYS_STARTEnd of change Start of change
TIMESTAMP(12)
NOT NULL
GENERATED ALWAYS
AS ROW BEGIN
End of change		 Start of changeReserved for future IBM® use.The row-begin column of the SYSTEM_TIME period, for system-period data versioning.End of change Start of changeGEnd of change
Start of changeSYS_ENDEnd of change Start of change
TIMESTAMP(12)
NOT NULL
GENERATED ALWAYS
AS ROW END
End of change		 Start of changeReserved for future IBM use.The row-end column of the SYSTEM_TIME period, for system-period data versioning.End of change Start of changeGEnd of change
Start of changeTRANS_STARTEnd of change Start of change
TIMESTAMP(12)
NOT NULL
GENERATED ALWAYS
AS TRANSACTION
START ID
End of change		 Start of changeReserved for future IBM use. End of change Start of changeGEnd of change