Outdated Version
You are viewing an older version of this section. View current production version.
SHOW ROLES FOR USER
Show roles for a specific user.
SHOW ROLES FOR user_specification
user_specification:
user
[
USER 'user_name'
]
Output
| Column | Description |
|---|---|
Roles of user user_name |
Roles of specified user |
Example
memsql> SHOW ROLES FOR USER 'root'@'localhost';
+- -----------------------------+
| Roles of user root@localhost |
+- -----------------------------+
| role_name_0 |
+- -----------------------------+
1 row in set (0.00 sec)
