SHOW ROLES statement
The SHOW ROLES statement displays all the roles created in the Ranger
server.
Syntax:
SHOW ROLESSHOW ROLES statement granted to a user
You can verify which roles are currently assigned to a specific user. Displays a list of roles currently assigned to the specified user.
The syntax for showing roles granted to a user is:
SHOW ROLE GRANT USER <user_name>;Example:
To list all roles assigned to the user getuser:
SHOW ROLE GRANT USER getuser;