Skip to content
Developer Edition runs on one host and does not require a product license file. Need multi-host deployment or performance testing at scale? Explore Enterprise Edition

SHOW ALL ROLES command

The SHOW ALL ROLES command returns information about all roles in the current service group.

The following table describes the returned information:

Column Description
name The name of the role.
owner The owner of the role.
comment The description of the role.

Prerequisites

Any user connected to the current service group can run this command.

Syntax

show_all_roles_command
SHOW ALL ROLES

show_all_roles_command ::=
    'SHOW' 'ALL' 'ROLES'

Examples

Show all roles

SHOW ALL ROLES

Return:

+-------+-------+---------------+
| name  | owner | comment       |
+-------+-------+---------------+
| ADMIN | root  | Builtin role  |
| role1 | root  | This is role1 |
+-------+-------+---------------+