-- -----------------------------------------------------------------------------------
-- File Name    : user_ords_privilege_modules.sql
-- Author       : DBA Learning Hub
-- Description  : Displays all ORDS privilege and associated modules.
-- Call Syntax  : @user_ords_privilege_modules
-- Last Modified: 15/07/2025
-- -----------------------------------------------------------------------------------
column name format a60
column pattern format a60

select s.parsing_schema, p.module_id, p.module_name, p.privilege_id, p.privilege_name
from   user_ords_privilege_modules p
       join user_ords_schemas s on s.id = p.schema_id
order by s.parsing_schema, p.module_name, p.privilege_name;