首页 项目目录 关于我们
Sign In
rust
/
Materialize
1
0
Fork 0
Files Issues 0 Pull Requests 0 Wiki
Tree: 6dd8e59864
Branches Tags
Materialize
/
doc
/
user
/
content
/
sql
/
show-role-membership.md

show-role-membership.md 1.2 KB
History Raw

title: "SHOW ROLE MEMBERSHIP" description: "SHOW ROLE MEMBERSHIP lists the members of each role granted via role-based access control (RBAC)." menu: main:

parent: 'commands'

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> ]

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

Related pages

Option Description
FOR If specified, only show membership for the specified role.