Description

This command is used to query all role information under the current database space. By executing this command, users can easily understand and manage the permission allocation in the database.

Workspace Role Management


SHOW ROLES [LIKE pattern];

Parameter Description

LIKE pattern (Optional): This parameter is used to filter by role name, displaying only the role information that matches the given pattern. The filter uses case-insensitive pattern matching and supports SQL wildcards % and _. For example, using LIKE '%admin%' will only display role information that contains the text "admin".

Usage Example

Query all roles in the current space:
```
SHOW ROLES;
```


2. Query role names containing the text "admin":


SHOW ROLES LIKE '%admin%';


3. Query detailed information of a specific role:


SHOW ROLES LIKE 'role_name';

其中，role_name 为需要查询的角色名称。

Notes

When executing this command, ensure that you have sufficient permissions to query role information.

Through the above instructions and examples, users can more easily understand and manage role information in the database. In practical applications, you can flexibly use the LIKE filter condition as needed to obtain the required data more efficiently.

Instance Role Management


SHOW INSTANCE ROLES [LIKE pattern];

Parameter Description

LIKE pattern (Optional): This parameter is used to filter roles by name, displaying only the roles that match the given pattern. The filter uses case-insensitive pattern matching and supports SQL wildcards % and _. For example, using LIKE '%admin%' will display only the roles that contain the text "admin".

Usage Example

Query all roles under the current instance:


SHOW INSTANCE ROLES;