SHOW ROLES FOR USER
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