VIEW: DVSYS.KU$_DV_ROLE_VIEW

Source

View Text - Preformatted

select '0','0',
         roles.role,
         roles.enabled,
         rulst.name
    from dvsys.role$         roles,
         dvsys.rule_set$     ruls,
         dvsys.rule_set_t$   rulst
   where roles.rule_set_id# = ruls.id#
     and ruls.id# = rulst.id#
     and roles.id# >= 5000
     and (SYS_CONTEXT('USERENV','CURRENT_USERID') = 1279990 OR
          EXISTS ( SELECT * FROM sys.session_roles
                   WHERE role='DV_OWNER' ))

View Text - HTML Formatted

SELECT '0'
, '0'
, ROLES.ROLE
, ROLES.ENABLED
, RULST.NAME
FROM DVSYS.ROLE$ ROLES
, DVSYS.RULE_SET$ RULS
, DVSYS.RULE_SET_T$ RULST
WHERE ROLES.RULE_SET_ID# = RULS.ID#
AND RULS.ID# = RULST.ID#
AND ROLES.ID# >= 5000
AND (SYS_CONTEXT('USERENV'
, 'CURRENT_USERID') = 1279990 OR EXISTS ( SELECT *
FROM SYS.SESSION_ROLES
WHERE ROLE='DV_OWNER' ))