Outdated Version

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

SHOW USERS FOR GROUP

Show users for a specific group.

SHOW USERS FOR GROUP 'group_name'

Output

Column Description
Users in group group_name Users in group
Connections Connections
Is deleted Is deleted

Example

memsql> SHOW USERS FOR GROUP 'group_0';
+------------------------+-------------+------------+
| Users in group group_0 | Connections | Is deleted |
+------------------------+-------------+------------+
| 'root'@'localhost'     |           1 |            |
+------------------------+-------------+------------+
1 row in set (0.00 sec)