Watch the 7.3 Webinar On-Demand
This new release brings updates to Universal Storage, query
optimization, and usability that you won’t want to miss.
Show roles for a specific user.
SHOW ROLES FOR USER user_specification
user_specification:
'user_name'@'host_name'
Output
Column | Description |
---|---|
Roles of user user_name |
Roles of specified user |
SHOW ROLES FOR USER 'root'@'localhost';
+- -----------------------------+
| Roles of user root@localhost |
+- -----------------------------+
| role_name_0 |
+- -----------------------------+
1 row in set (0.00 sec)
Related Topics