SingleStore Managed Service

CURRENT_SECURITY_ROLES

Returns a comma separated list in one row of the current user's security roles on a SingleStore cluster.

Syntax
SELECT CURRENT_SECURITY_ROLES();

Output

Column

Description

CURRENT_SECURITY_ROLES()

List of a user's security role names

Example
SELECT CURRENT_SECURITY_ROLES();
+-------------------------------------+
| CURRENT_SECURITY_ROLES()            |
+-------------------------------------+
| role_name_0,role_name_1,role_name_2 |
+-------------------------------------+
1 row in set (0.00 sec)

Related Topic