Lists all roles a granted to a given user.

Syntax

GRANT

SHOW ROLE GRANT USER principal_name;
SQL

principal_specification

USER followed by name of the user.

principal_name

Name of a user.


Any user can run this command.