SingleStore Managed Service

CURRENT_SECURITY_GROUPS

Returns a comma separated list of the current user's security groups on a SingleStore cluster.

Syntax
SELECT CURRENT_SECURITY_GROUPS();

Output

Column

Description

CURRENT_SECURITY_GROUPS()

List of a user's security group names

Example
SELECT CURRENT_SECURITY_GROUPS();
+----------------------------------------+
| CURRENT_SECURITY_GROUPS()              |
+----------------------------------------+
| group_name_0,group_name_1,group_name_2 |
+----------------------------------------+
1 row in set (0.00 sec)

Related Topic