-- -----------------------------------------------------------------------------------
-- File Name    : user_ords_client_roles.sql
-- Author       : DBA Learning Hub
-- Description  : Displays all ORDS client roles.
-- Call Syntax  : @v_ords_client_roles
-- Last Modified: 15/07/2025
-- -----------------------------------------------------------------------------------
column client_name format a30
column role_name format a20

select client_id, client_name, role_id, role_name
from   user_ords_client_roles
order by client_name, role_name;