SHOW ROLES
SHOW ROLES lists the roles available in Materialize.
Syntax
SHOW ROLES [ LIKE <pattern> | WHERE <condition(s)> ];
| Syntax element | Description |
|---|---|
| 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
SHOW ROLES;
name
----------------
[email protected]
[email protected]
SHOW ROLES LIKE 'jo%';
name
----------------
[email protected]
SHOW ROLES WHERE name = '[email protected]';
name
----------------
[email protected]