SHOW ROLES FOR USER

On this page

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

SHOW ROLES FOR USER 'root'@'localhost';
+------------------------------+
| Roles of user root@localhost |
+------------------------------+
| role_name_0                  |
+------------------------------+
1 row in set (0.00 sec)

Related Topics

Last modified: August 18, 2023

Was this article helpful?