SHOW USERS FOR ROLE
On this page
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
Last modified: August 18, 2023