VIEW: DVSYS.KU$_DV_REALM_AUTH_VIEW

Source

View Text - Preformatted

select '0','0',
          rlmt.name,
          rlma.grantee,
          rs.name,
          decode(rlma.auth_options,
                 0,'DVSYS.DBMS_MACUTL.G_REALM_AUTH_PARTICIPANT',
                 1,'DVSYS.DBMS_MACUTL.G_REALM_AUTH_OWNER',
                 to_char(rlma.auth_options))
  from    dvsys.realm$                   rlm,
          dvsys.realm_t$                 rlmt,
          dvsys.dv$realm_auth              rlma,
          (select m.id#,
                  d.name
             from dvsys.rule_set$   m,
                  dvsys.rule_set_t$ d
            where m.id# = d.id#)         rs
  where   rlm.id# = rlma.realm_id#
    and   rlm.id# = rlmt.id#
    and   rs.id# (+)= rlma.auth_rule_set_id#
    and   rlm.id# > 5000
    and   (SYS_CONTEXT('USERENV','CURRENT_USERID') = 1279990
           or exists ( select 1
                         from sys.session_roles
                        where role='DV_OWNER' ))

View Text - HTML Formatted

SELECT '0'
, '0'
, RLMT.NAME
, RLMA.GRANTEE
, RS.NAME
, DECODE(RLMA.AUTH_OPTIONS
, 0
, 'DVSYS.DBMS_MACUTL.G_REALM_AUTH_PARTICIPANT'
, 1
, 'DVSYS.DBMS_MACUTL.G_REALM_AUTH_OWNER'
, TO_CHAR(RLMA.AUTH_OPTIONS))
FROM DVSYS.REALM$ RLM
, DVSYS.REALM_T$ RLMT
, DVSYS.DV$REALM_AUTH RLMA
, (SELECT M.ID#
, D.NAME
FROM DVSYS.RULE_SET$ M
, DVSYS.RULE_SET_T$ D
WHERE M.ID# = D.ID#) RS
WHERE RLM.ID# = RLMA.REALM_ID#
AND RLM.ID# = RLMT.ID#
AND RS.ID# (+)= RLMA.AUTH_RULE_SET_ID#
AND RLM.ID# > 5000
AND (SYS_CONTEXT('USERENV'
, 'CURRENT_USERID') = 1279990 OR EXISTS ( SELECT 1
FROM SYS.SESSION_ROLES
WHERE ROLE='DV_OWNER' ))