Outdated Version
You are viewing an older version of this section. View current production version.
SHOW USERS FOR ROLE
Show 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 |
Example
memsql> SHOW USERS FOR ROLE 'role_name_0';
+-----------------------------+-------------+------------+
| Users with role role_name_0 | Connections | Is deleted |
+-----------------------------+-------------+------------+
| 'root'@'localhost' | 1 | |
+-----------------------------+-------------+------------+
1 row in set (0.00 sec)