To show the data of one or all existing roles, including the role
description and privileges, type show roles
<role_name>, and press Enter.
<role_name> is the name of the role whose permissions you want to
query. The variable can be one of the options:
all shows all existing roles or a
role name to show the data of the specified
role only.
Note -
You can type the show roles command without adding
the all option to get the same data.