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

  • 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"}          |
+------------------------------------------------------+