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
Default resource pool the default resource pool name when user starts a connection

Example

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

Related Topics