This Information Schema view displays a row for each currently-enabled role in the session. A role is enabled if it is currently in use in the session or it has been granted to the role that is currently in use.
For more information about roles, see Access Control in Snowflake.
|Column Name||Data Type||Description|
|ROLE_NAME||TEXT||Name of the role|
|ROLE_OWNER||TEXT||Owner of the role|
- The view only displays objects for which the current role for the session has been granted access privileges.
- The view always displays the PUBLIC role because it is always enabled.