Outdated Version

You are viewing an older version of this section. View current production version.

SHOW USERS FOR ROLE

Show users for a specific role.

SHOW USERS FOR '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)