TABLE_PRIVILEGES View

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.

See also:
APPLICABLE_ROLES View , ENABLED_ROLES View , OBJECT_PRIVILEGES View

Columns

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

Usage Notes

  • 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).