SHOW ROLE GRANT statement
The SHOW ROLE GRANT GROUP statement displays the roles assigned to the group & SHOW ROLE GRANT USER displays the roles assigned to the user.
SHOW ROLES statement granted to a group
The syntax for showing roles granted to a group is:
SHOW ROLE GRANT GROUP group_nameSHOW 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;