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)