MySQL 8 Administrator???s Guide

SHOW GRANTS

SHOW GRANTS lists down privileges and role assignments related to accounts and roles. For a role, execute the following command:

mysql> show grants for app_developer;+-------------------------------------------+| Grants for app_developer@% |+-------------------------------------------+| GRANT USAGE ON *.* TO `app_developer`@`%` |+-------------------------------------------+1 row in set (0.05 sec)

This command shows the grant available on the 'app_developer' role. In the same way, to check grants on a user, execute the following command:

mysql> show grants for root@localhost;

The preceding command lists down all the access available with the user root:

• CURRENT_ROLE (): This function is used to list current roles within the current ...