Roles that have been Granted to other Roles

SET SERVEROUTPUT ON
SET ECHO OFF
SET FEEDBACK OFF
SET PAGES 800
SET LINES 132

REM
REM
REM || Title : show_roles_roles.sql
REM ||
REM || Purpose : Script which display Roles that have been granted to other Roles.
REM ||
REM || Release No : 1
REM ||
REM || Variables : None
REM ||
REM || Schema : system
REM ||
REM


Break on role skip 1

COLUMN role FORMAT A25 HEADING 'Role'
COLUMN granted_role FORMAT A25 HEADING 'Granted Role'
COLUMN admin_option FORMAT A30 HEADING 'Admin Option'

SELECT role,
granted_role,
admin_option
FROM role_role_privs
ORDER BY role


SPOOL show_role_role_privs.lst
/
SPOOL OFF

SET SERVEROUTPUT ON
SET ECHO OFF
SET FEEDBACK OFF
SET PAGES 60

CLEAR BREAKS
CLEAR COL
This script is provided for educational purposes only. The script has been tested and appears to work as intended. However, you should always test any script before relying on it. No responsibility will be accepted for Lost or damage that may occur from it's use.