SHOW ROLES

SHOW ROLES lists the roles available in Materialize.

Syntax

SHOW ROLES LIKE pattern WHERE expr

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
Back to top ↑