SHOW ROLE MEMBERSHIP
SHOW ROLE MEMBERSHIP lists the members of each role granted via
role-based access control (RBAC).
Syntax
| Field | Use |
|---|---|
| role_name | Only shows role memberships granted directly or indirectly to role_name. |
Examples
SHOW ROLE MEMBERSHIP;
role | member | grantor
------+--------+-----------
r2 | r1 | mz_system
r3 | r2 | mz_system
r4 | r3 | mz_system
r6 | r5 | mz_system
SHOW ROLE MEMBERSHIP FOR r2;
role | member | grantor
------+--------+-----------
r3 | r2 | mz_system
r4 | r3 | mz_system