SHOW USERS FOR ROLE
Show users for a specific role.
Syntax
SHOW USERS FOR ROLE 'role_name'
Output
Column | Description |
|---|---|
| User with role |
| Connections |
| Is deleted |
| the default resource pool name when user starts a connection |
Example
SHOW USERS FOR ROLE 'role_name_0'; +-----------------------------+-------------+------------+-----------------------+ | Users with role role_name_0 | Connections | Is deleted | Default resource pool | +-----------------------------+-------------+------------+-----------------------+ | 'root'@'localhost' | 1 | | | +-----------------------------+-------------+------------+-----------------------+ 1 row in set (0.00 sec)
Related Topics