You are viewing an older version of this section. View current production version.
Join the MemSQL Community Today
Get expert advice, develop skills, and connect with others.

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 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)

Related Topics