SHOW ROLE MEMBERSHIP
SHOW ROLE MEMBERSHIP lists the members of each role granted (directly or
indirectly) via role-based access
control (RBAC).
Syntax
SHOW ROLE MEMBERSHIP [ FOR <role_name> ]
| Option | Description |
|---|---|
| FOR <role_name> | If specified, only show membership for the specified role. |
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