Important

The SingleStore 9.1 release candidate (RC) gives you the opportunity to preview, evaluate, and provide feedback on new and upcoming features prior to their general availability. In the interim, SingleStore 9.0 is recommended for production workloads, which can later be upgraded to SingleStore 9.1.

SHOW ROLES

Syntax

SHOW ROLES [LIKE 'pattern'];

Output

Column	Description
`ROLES`	Role name

Remarks

LIKE: allows users to find roles matching a specific naming pattern.The pattern can include wildcard characters, such as %, to represent zero or more characters in the search string.
```
SHOW ROLES LIKE 'xyz';
```

The information_schema.ROLES view provides metadata about the roles configured within the workspace or cluster.
A user with the SHOW METADATA or GRANT permission can list all roles. Without these permissions, role visibility follows the general information schema access rules. Refer to Accessing the Information Schema for more information.

Example

SQL

SHOW ROLES;

+-------------+
| Roles       |
+-------------+
| role_name_0 |
| role_name_1 |
| role_name_2 |
| role_name_3 |
+-------------+
4 rows in set (0.00 sec)

Related Topics