SHOW ROLE GRANT ​

Lists all roles a granted to a given user.

Syntax ​

sql
SHOW ROLE GRANT USER principal_name;

principal_specification ​

USER followed by name of the user.

principal_name ​

Name of a user.

INFO

Any user can run this command.