APPLICABLE_ROLES View¶
This Information Schema view displays one row for each role grant. Roles can be granted to individual users and other roles.
For more information about roles and grants, see Access Control in Snowflake.
Columns¶
Column Name |
Data Type |
Description |
---|---|---|
GRANTEE |
TEXT |
Role or user to whom the privilege is granted |
ROLE_NAME |
TEXT |
Name of the role |
ROLE_OWNER |
TEXT |
Owner of the role |
IS_GRANTABLE |
TEXT |
Whether this role can be granted to others |
Usage Notes¶
The view only displays objects for which the current role for the session has been granted access privileges.