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.

See also:
ENABLED_ROLES View , OBJECT_PRIVILEGES View , TABLE_PRIVILEGES View

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.