The column_privileges view provides information about privileges granted on columns.
| Column name | Data type | Description |
|---|---|---|
grantor |
sql_identifier |
The name of the role that granted the privilege. |
grantee |
sql_identifier |
The name of the role to which the privilege was granted. |
table_catalog |
sql_identifier |
The name of the current database holding the table with the column. |
table_schema |
sql_identifier |
The name of the schema holding the table with the column. |
table_name |
sql_identifier |
The name of the table holding the column. |
column_name |
sql_identifier |
The name of the column. |
privilege_type |
character_data |
The type of the privilege. The possible values are:
|
is_grantable |
yes_or_no |
Specifies whether the privilege is grantable (YES) or not (NO). |