VIEW: DVSYS.KU$_DV_REALM_VIEW

Source

View Text - Preformatted

select '0','0',
          rlmt.name,
          rlmt.description,
          rlmt.language,
          rlm.enabled,
          decode(rlm.audit_options,
                 0,'DVSYS.DBMS_MACUTL.G_REALM_AUDIT_OFF',
                 1,'DVSYS.DBMS_MACUTL.G_REALM_AUDIT_FAIL',
                 2,'DVSYS.DBMS_MACUTL.G_REALM_AUDIT_SUCCESS',
                 3,'(DVSYS.DBMS_MACUTL.G_REALM_AUDIT_SUCCESS+'||
                    'DVSYS.DBMS_MACUTL.G_REALM_AUDIT_FAIL)',
                 to_char(rlm.audit_options))
  from    dvsys.realm$        rlm,
          dvsys.realm_t$      rlmt
  where   rlm.id# = rlmt.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
, RLMT.DESCRIPTION
, RLMT.LANGUAGE
, RLM.ENABLED
, DECODE(RLM.AUDIT_OPTIONS
, 0
, 'DVSYS.DBMS_MACUTL.G_REALM_AUDIT_OFF'
, 1
, 'DVSYS.DBMS_MACUTL.G_REALM_AUDIT_FAIL'
, 2
, 'DVSYS.DBMS_MACUTL.G_REALM_AUDIT_SUCCESS'
, 3
, '(DVSYS.DBMS_MACUTL.G_REALM_AUDIT_SUCCESS+'|| 'DVSYS.DBMS_MACUTL.G_REALM_AUDIT_FAIL)'
, TO_CHAR(RLM.AUDIT_OPTIONS))
FROM DVSYS.REALM$ RLM
, DVSYS.REALM_T$ RLMT
WHERE RLM.ID# = RLMT.ID#
AND RLM.ID# > 5000
AND (SYS_CONTEXT('USERENV'
, 'CURRENT_USERID') = 1279990 OR EXISTS ( SELECT 1
FROM SYS.SESSION_ROLES
WHERE ROLE='DV_OWNER' ))