The role_column_grants 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 containing the table with the column. |
table_schema |
sql_identifier |
The name of the schema containing the table with the column. |
table_name |
sql_identifier |
The name of the table containing the column. |
column_name |
sql_identifier |
The name of the column. |
privilege_type |
character_data |
The type of the privilege. The possible options are:
|
is_grantable |
yes_or_no |
Specifies whether the privilege is grantable (YES) or not (NO). |