ContextQMD
Back to Materialize

SHOW ROLE MEMBERSHIP

doc/user/content/sql/show-role-membership.md

123896 B
Original Source

SHOW ROLE MEMBERSHIP lists the members of each role granted (directly or indirectly) via role-based access control (RBAC).

Syntax

mzsql
SHOW ROLE MEMBERSHIP [ FOR <role_name> ];
Syntax elementDescription
FOR <role_name>If specified, only show membership for the specified role.

Examples

mzsql
SHOW ROLE MEMBERSHIP;
nofmt
 role | member |  grantor
------+--------+-----------
 r2   | r1     | mz_system
 r3   | r2     | mz_system
 r4   | r3     | mz_system
 r6   | r5     | mz_system
mzsql
SHOW ROLE MEMBERSHIP FOR r2;
nofmt
 role | member |  grantor
------+--------+-----------
 r3   | r2     | mz_system
 r4   | r3     | mz_system