SHOW ROLES FOR USER
On this page
Show roles for a specific user.
Syntax
SHOW ROLES FOR USER user_specification
user_specification:
'user_name'@'host_name'Output
|
Column |
Description |
|---|---|
|
|
Roles of specified user |
Example
SHOW ROLES FOR USER 'root'@'localhost';
+------------------------------+
| Roles of user root@localhost |
+------------------------------+
| role_name_0 |
+------------------------------+
1 row in set (0.00 sec)Related Topics
Last modified: August 18, 2023