Watch the 7.3 Webinar On-Demand
This new release brings updates to Universal Storage, query
optimization, and usability that you won’t want to miss.
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
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
