OBJECT_PRIVILEGES View

This Information Schema view displays a row for each access privilege granted for all objects defined in your account. It includes the privileges displayed in the TABLE_PRIVILEGES View and USAGE_PRIVILEGES View.

For more information about privileges and their impact on object access, see Access Control in Snowflake.

See also:

APPLICABLE_ROLES View , ENABLED_ROLES View , TABLE_PRIVILEGES View

Columns

Column Name

Data Type

Description

GRANTOR

TEXT

Role who granted the privilege

GRANTEE

TEXT

Role to whom the privilege is granted

OBJECT_CATALOG

TEXT

Database containing the object on which the privilege is granted

OBJECT_SCHEMA

TEXT

Schema containing the object on which the privilege is granted

OBJECT_NAME

TEXT

Name of the object on which the privilege is granted

OBJECT_TYPE

TEXT

Type of the object 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

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.