SHOW ROLE GRANT
Lists all roles a granted to a given user.
Syntax
GRANT
SQL
SHOW ROLE GRANT USER principal_name;principal_specification
USER followed by name of the user.
principal_name
Name of a user.
Any user can run this command.