CURRENT_ SECURITY_ ROLES
Warning
SingleStore 9.0 gives you the opportunity to preview, evaluate, and provide feedback on new and upcoming features prior to their general availability. In the interim, SingleStore 8.9 is recommended for production workloads, which can later be upgraded to SingleStore 9.0.
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