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)
