Important

The SingleStore 9.1 release candidate (RC) is available now. It will be promoted to general availability (GA) soon and at that time it will be renamed to SingleStore 10.

In the interim, SingleStore 9.1 RC can be used to preview, evaluate, and provide feedback on the new and upcoming features in SingleStore 10, while SingleStore 9.0 is recommended for production workloads.

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 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