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

SHOW USERS FOR GROUP

Show users for a specific group.

Syntax

SHOW USERS FOR GROUP 'group_name'

Output

Column Description
Users in group group_name Users in group
Connections Connections
Is deleted Is deleted
Default resource pool the default resource pool name when user starts a connection

Example

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

Related Topics