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 38. SYSCAT.COLAUTH Catalog View
| Column Name | Data Type | Nullable | Description |
|---|---|---|---|
| GRANTOR | CHAR(8) |
| Authorization ID of the user who granted the privileges or SYSIBM. |
| GRANTEE | CHAR(8) |
| 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 | CHAR(8) |
| Qualified name of the table or view. |
| TABNAME | VARCHAR(18) |
| |
| COLNAME | VARCHAR(18) |
| 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. |