Displaying assigned roles using SHOW GRANTS

If you want to see the roles assigned to a user, use the SHOW GRANTS statement as follows:

mysql> SHOW GRANTS FOR 'user_dev@localhost';

It will display the roles and usage granted to the user: user_dev. The following is the sample output:

+--------------------------------------------------+
| Grants for user_dev@localhost@% |
+--------------------------------------------------+
| GRANT USAGE ON *.* TO `user_dev@localhost`@`%` |
| GRANT `user_dev`@`%` TO `user_dev@localhost`@`%` |
+--------------------------------------------------+

This output specifies that it has usage granted on all the tables of all the databases (*.*).

The second row provides the name of the role assigned/granted to the user. So what if you want to see the privileges contained in that role?

You have to use the following statement, which includes the USING...