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_name