COLUMN_PRIVILEGES
The COLUMN_PRIVILEGES system view lists privileges on table columns that were granted by the current ident and privileges on table columns that were granted to the current ident or to PUBLIC.
Granting a privilege on an entire table implicitly grants privileges on each of the table columns (as well as on future columns in the table), each of which is shown in this view.
The view includes rows that represent the implicit privileges that the creator of a table has on the table.
A row will be shown for each instance of a privilege granted on each table column (whether or not the specified privilege can be granted or revoked on individual columns), the exception is DELETE which can never apply to an individual column.
Column name
|
Data type
|
Description
|
| GRANTOR |
VARCHAR(128) |
The name of the ident who granted the privilege. For rows that describe the implicit privileges that a table creator has on each column in a table, the name "_SYSTEM" is shown. |
| GRANTEE |
VARCHAR(128) |
The name of the ident to whom the privilege was granted. Granting a privilege to PUBLIC will result in only one row (per privilege granted) in this view and the name "PUBLIC" will be shown. |
| TABLE_CAT |
VARCHAR(128) |
The name of the catalog containing the table. |
| TABLE_SCHEM |
VARCHAR(128) |
The name of the schema containing the table. |
| TABLE_NAME |
VARCHAR(128) |
The name of the table containing the column on which the column privilege has been granted. |
| COLUMN_NAME |
VARCHAR(128) |
The name of the column on which the privilege has been granted. |
| PRIVILEGE_TYPE |
VARCHAR(20) |
A value describing the type of the column privilege that was granted. One of:
"INSERT"
"REFERENCES"
"SELECT"
"UPDATE".
Note that when multiple table column privileges are granted to the same user at the same time (e.g. when the keyword "ALL" is used), multiple rows appear in this view (one for each privilege granted). |
| IS_GRANTABLE |
VARCHAR(3) |
One of:
"YES" = the privilege is held with the WITH GRANT OPTION
"NO" = the privilege is held without the WITH GRANT OPTION. |
| REMARKS |
VARCHAR(254) |
May contain descriptive information about the privilege. |
