DB2 Version 9.7 for Linux, UNIX, and Windows

SYSCAT.COLAUTH catalog view

Each row represents a user, group, or role that has been granted one or more privileges on a column.

Table 1. SYSCAT.COLAUTH Catalog View
Column Name Data Type Nullable Description
GRANTOR VARCHAR (128)   Grantor of a privilege.
GRANTORTYPE CHAR (1)  
  • S = Grantor is the system
  • U = Grantor is an individual user
GRANTEE VARCHAR (128)   Holder of a privilege.
GRANTEETYPE CHAR (1)  
  • G = Grantee is a group
  • R = Grantee is a role
  • U = Grantee is an individual user
TABSCHEMA VARCHAR (128)   Schema name of the table or view on which the privilege is held.
TABNAME VARCHAR (128)   Unqualified name of the table or view on which the privilege is held.
COLNAME VARCHAR (128)   Name of the column to which this privilege applies.
COLNO SMALLINT   Column number of this column within the table (starting with 0).
PRIVTYPE CHAR (1)  
  • R = Reference privilege
  • U = Update privilege
GRANTABLE CHAR (1)  
  • G = Privilege is grantable
  • N = Privilege is not grantable
Note:
  1. Privileges can be granted by column, but can be revoked only on a table-wide basis.