SingleStore DB

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