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.