LIST ROLES

Syntax

{ LIST | SHOW } ROLES;

Description

1. LIST ROLES

Examples

<no-db>/<no-store># LIST ROLES;
      Name      | Current |      Created at       
----------------+---------+-----------------------
  public        |         | 2023-09-11T19:46:20Z  
  orgadmin      | ✓       | 2023-09-11T19:46:20Z  
  securityadmin |         | 2023-09-11T19:46:20Z  
  useradmin     |         | 2023-09-11T19:46:20Z  
  sysadmin      |         | 2023-09-11T19:46:20Z  

<no-db>/<no-store># LIST USER ROLES;
      Name      | Inherited | Current | Default  
----------------+-----------+---------+----------
  orgadmin      |           | ✓       | ✓        
  public        |           |         |          
  securityadmin | ✓         |         |          
  useradmin     | ✓         |         |          
  sysadmin      | ✓         |         |