ContextQMD
Back to Materialize

SHOW ROLES

doc/user/content/sql/show-roles.md

123761 B
Original Source

SHOW ROLES lists the roles available in Materialize.

Syntax

mzsql
SHOW ROLES [ LIKE <pattern>  | WHERE <condition(s)> ];
Syntax elementDescription
LIKE <pattern>If specified, only show roles whose name matches the pattern.
WHERE <condition(s)>If specified, only show roles that meet the condition(s).

Examples

mzsql
SHOW ROLES;
nofmt
 name
----------------
 [email protected]
 [email protected]
mzsql
SHOW ROLES LIKE 'jo%';
nofmt
 name
----------------
 [email protected]
mzsql
SHOW ROLES WHERE name = '[email protected]';
nofmt
 name
----------------
 [email protected]