首页 项目目录 关于我们
Sign In
rust
/
Materialize
1
0
Fork 0
Files Issues 0 Pull Requests 0 Wiki
Tree: 6dd8e59864
Branches Tags
Materialize
/
doc
/
user
/
content
/
sql
/
show-roles.md

show-roles.md 898 B
History Raw

title: "SHOW ROLES" description: "SHOW ROLES lists the roles available in Materialize." menu: main:

parent: 'commands'

SHOW ROLES lists the roles available in Materialize.

Syntax

SHOW ROLES [ LIKE <pattern>  | WHERE <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

Related pages

Option Description
LIKE <pattern> If specified, only show roles whose name matches the pattern.
WHERE If specified, only show roles that meet the condition(s).