CURRENT_SECURITY_ROLES

On this page

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

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

Last modified: August 18, 2023

Was this article helpful?