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.
|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|
- The view only displays objects for which the current role for the session has been granted access privileges.