Show Roles

The show roles command a sorted list of all of the roles that have been defined in the database.

Use the “values current_role;” statement to display the list of roles that are active in the current session.

Syntax

SHOW ROLES

Examples

splice> create role testRole;
0 rows inserted/updated/deleted
splice> show roles;

ROLEID
------------------------------
ADMIN, EDITOR, WRITER

1 row selected