# SHOW ROLES

The `SHOW ROLES` statement lists the roles for all databases.

## Synopsis

## Required privileges

The user must have the `SELECT` privilege on the system table.

## Example

    > SHOW ROLES;

    +-----------+
    | role_name |
    +-----------+
    | admin     |
    | dev_ops   |
    +-----------+

## See also

- `CREATE ROLE` (Enterprise)
- `DROP ROLE` (Enterprise)
- `GRANT <privileges>`
- `REVOKE <privileges`
- `GRANT <roles>` (Enterprise)
- `REVOKE <roles` (Enterprise)
- Manage Roles
- Manage Users