SYSCOLAUTH
The SYSCOLAUTH view contains one row for every privilege granted on a column. Note that this catalog view cannot be used to determine whether a user is authorized to a column because the privilege to use a column could be acquired through a group user profile or special authority (such as *ALLOBJ). Furthermore, the privilege to use a column is also acquired through privileges granted on the table.
The following table describes the columns in the SYSCOLAUTH view:
| Column Name | System Column Name | Data Type | Description |
|---|---|---|---|
| GRANTOR | GRANTOR | VARCHAR(128) Nullable |
Reserved. Contains the null value. |
| GRANTEE | GRANTEE | VARCHAR(128) | The user profile to which the privilege is granted. |
| TABLE_SCHEMA | DBNAME | VARCHAR(128) | Name of the schema |
| TABLE_NAME | TBNAME | VARCHAR(128) | Name of the table |
| COLUMN_NAME | NAME | VARCHAR(128) | Name of the column |
| PRIVILEGE_TYPE | PRIVTYPE | VARCHAR(10) | The privilege granted:
|
| IS_GRANTABLE | GRANTABLE | VARCHAR(3) | Indicates whether the privilege is grantable to other users.
|
| AUTHORIZATION_LIST | AUTL | VARCHAR(10) Nullable |
Contains the null value. |
| SYSTEM_TABLE_SCHEMA | SYS_DNAME | CHAR(10) | System name of the schema |
| SYSTEM_TABLE_NAME | SYS_TNAME | CHAR(10) | System name of the table or view |
| SYSTEM_COLUMN_NAME | SYS_CNAME | CHAR(10) | System name of the column |
