This Information Schema view displays a row for each table privilege that has been granted to each role in the specified (or current) database.
For more information about roles and privileges, see Access Control in Snowflake.
|Column Name||Data Type||Description|
|GRANTOR||TEXT||Role who granted the table privilege|
|GRANTEE||TEXT||Role to whom the table privilege is granted|
|TABLE_CATALOG||TEXT||Database containing the table on which the privilege is granted|
|TABLE_SCHEMA||TEXT||Schema containing the table on which the privilege is granted|
|TABLE_NAME||TEXT||Name of the table on which the privilege is granted|
|PRIVILEGE_TYPE||TEXT||Type of the granted privilege|
|IS_GRANTABLE||TEXT||Whether the privilege was granted WITH GRANT OPTION|
|WITH_HIERARCHY||TEXT||Not applicable for Snowflake.|
|CREATED||TIMESTAMP_LTZ||Creation time of the privilege|
- The view only displays objects for which the current role for the session has been granted access privileges.
- The PRIVILEGE_TYPE column contains Snowflake privilege types. For example, the owner of a table has the OWNERSHIP privilege, rather than each of the separate privileges (e.g. SELECT, INSERT, DELETE, UPDATE).