CURRENT_ SECURITY_ ROLES
On this page
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 |
---|---|
|
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