SHOW USERS FOR ROLE

On this page

The SHOW USERS FOR ROLE command shows users for a specific role.

Syntax

SHOW USERS FOR ROLE 'role_name'

Output

Column

Description

User with role role_name

User with role

Connections

Connections

Is deleted

Is deleted

Default resource pool

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:

Was this article helpful?