- Categories:
Context functions (Session Object)
CURRENT_SECONDARY_ROLES¶
Returns the name of the secondary roles in use for the current session.
To activate a different set of secondary roles for the session, execute the USE SECONDARY ROLES command.
Syntax¶
CURRENT_SECONDARY_ROLES()
Arguments¶
None.
Usage notes¶
Note that this function only returns the name of the account-level role, not the name of the database role.
Granting access on a secure UDF or secure view that contains CURRENT_SECONDARY_ROLES to a share is allowed. When the secure UDF or secure view is accessed from the data sharing consumer account, CURRENT_SECONDARY_ROLES always returns a NULL value.
Examples¶
Custom roles role1
, role2
, and role3
have been granted to the current user and are active as secondary roles:
SELECT CURRENT_SECONDARY_ROLES();
Output:
+------------------------------------------------------+ | CURRENT_SECONDARY_ROLES() | +------------------------------------------------------+ | {"roles":"ROLE1,ROLE2,ROLE3","value":"ALL"} | +------------------------------------------------------+