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

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