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 |
|---|---|
| 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