VIEW: DVSYS.KU$_DV_ISRM_VIEW

Source

View Text - Preformatted

select '0','0',
         realm_objects.object_owner
    from (select distinct(objects_in_realm.owner) object_owner
            from dvsys.dv$realm_object objects_in_realm
           where objects_in_realm.REALM_ID# > 5000) realm_objects
   where (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'
, REALM_OBJECTS.OBJECT_OWNER
FROM (SELECT DISTINCT(OBJECTS_IN_REALM.OWNER) OBJECT_OWNER
FROM DVSYS.DV$REALM_OBJECT OBJECTS_IN_REALM
WHERE OBJECTS_IN_REALM.REALM_ID# > 5000) REALM_OBJECTS
WHERE (SYS_CONTEXT('USERENV'
, 'CURRENT_USERID') = 1279990 OR EXISTS (SELECT 1
FROM SYS.SESSION_ROLES
WHERE ROLE='DV_OWNER'))