You are viewing an older version of this section. View current production version.
Join the SingleStore Community Today
Get expert advice, develop skills, and connect with others.

SHOW USERS FOR ROLE

Show users for a specific role.

Syntax

SHOW USERS FOR ROLE 'role_name'

Output

Column Description
User with role role_name User with role
Connections Connections
Is deleted Is deleted

Example

memsql> SHOW USERS FOR ROLE 'role_name_0'; 
+-----------------------------+-------------+------------+
| Users with role role_name_0 | Connections | Is deleted |
+-----------------------------+-------------+------------+
| 'root'@'localhost'          |           1 |            |
+-----------------------------+-------------+------------+
1 row in set (0.00 sec)

Related Topics