SHOW ROLES
SHOW ROLES lists the roles available in Materialize.
Syntax
SHOW ROLES [ LIKE <pattern> | WHERE <condition(s)> ]
| Option | 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
----------------
joe@ko.sh
mike@ko.sh
SHOW ROLES LIKE 'jo%';
name
----------------
joe@ko.sh
SHOW ROLES WHERE name = 'mike@ko.sh';
name
----------------
mike@ko.sh