VIEW: DVSYS.KU$_DV_COMMAND_RULE_VIEW

Source

View Text - Preformatted

select '0','0',
          command,
          rule_set_name,
          object_owner,
          object_name,
          enabled
  from    dvsys.dv$command_rule         cvcr
  where   cvcr.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'
, COMMAND
, RULE_SET_NAME
, OBJECT_OWNER
, OBJECT_NAME
, ENABLED
FROM DVSYS.DV$COMMAND_RULE CVCR
WHERE CVCR.ID# >= 5000
AND (SYS_CONTEXT('USERENV'
, 'CURRENT_USERID') = 1279990 OR EXISTS ( SELECT 1
FROM SYS.SESSION_ROLES
WHERE ROLE='DV_OWNER' ))