VIEW: DVSYS.KU$_DV_REALM_MEMBER_VIEW

Source

View Text - Preformatted

select '0','0',sys_guid(),
          rlmt.name,
          rlmo.owner,
          rlmo.object_name,
          rlmo.object_type
  from    dvsys.realm$        rlm,
          dvsys.realm_t$      rlmt,
          dvsys.dv$realm_object rlmo
  where   rlm.id# = rlmt.id#
    and   rlmo.realm_id# = rlm.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'
, SYS_GUID()
, RLMT.NAME
, RLMO.OWNER
, RLMO.OBJECT_NAME
, RLMO.OBJECT_TYPE
FROM DVSYS.REALM$ RLM
, DVSYS.REALM_T$ RLMT
, DVSYS.DV$REALM_OBJECT RLMO
WHERE RLM.ID# = RLMT.ID#
AND RLMO.REALM_ID# = RLM.ID#
AND RLM.ID# > 5000
AND (SYS_CONTEXT('USERENV'
, 'CURRENT_USERID') = 1279990 OR EXISTS ( SELECT 1
FROM SYS.SESSION_ROLES
WHERE ROLE='DV_OWNER' ))