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 44. 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

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

[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]

[ DB2 List of Books | Search the DB2 Books ]