VIEW: LBACSYS.DBA_SA_GROUP_HIERARCHY

Source

View Text - Preformatted

SELECT l.pol_name AS policy_name, g.hierarchy_level, g.group_name
   FROM ( SELECT LEVEL AS hierarchy_level,
            RPAD(' ',2*LEVEL,' ') || code || ' - ' ||  name AS group_name,
            pol#
        FROM LBACSYS.ols$groups
        CONNECT BY PRIOR pol#=pol# AND PRIOR group#=parent#
        START WITH parent# IS NULL) g, ols$pol l
   WHERE g.pol#=l.pol#

View Text - HTML Formatted

SELECT L.POL_NAME AS POLICY_NAME
, G.HIERARCHY_LEVEL
, G.GROUP_NAME
FROM ( SELECT LEVEL AS HIERARCHY_LEVEL
, RPAD(' '
, 2*LEVEL
, ' ') || CODE || ' - ' || NAME AS GROUP_NAME
, POL#
FROM LBACSYS.OLS$GROUPS CONNECT BY PRIOR POL#=POL#
AND PRIOR GROUP#=PARENT# START WITH PARENT# IS NULL) G
, OLS$POL L
WHERE G.POL#=L.POL#