A command that lists all users of a particular role.

Syntax

GRANT

SHOW PRINCIPALS principal_name;
SQL

privilege_name

Name of the role.