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