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 Overview of Access Control.

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
GRANTED_TO	TEXT	Type of object that has been granted the privilege
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).