VIEW: DVSYS.DBA_DV_COMMAND_RULE

Source

View Text - Preformatted

SELECT
      d2.code
    , d1.name
    , u.name
    , m.object_name
    , m.enabled
    , m.privilege_scope
FROM dvsys.command_rule$ m
    ,dvsys.dv$rule_set d1
    ,dvsys.dv$code d2
    ,sys.user$ u
WHERE
    d1.id# = m.rule_set_id#
    AND d2.id# = m.code_id#
    AND m.object_owner_uid# = u.user#
UNION
SELECT
      d2.code
    , d1.name
    , '%'
    , m.object_name
    , m.enabled
    , m.privilege_scope
FROM dvsys.command_rule$ m
    ,dvsys.dv$rule_set d1
    ,dvsys.dv$code d2
WHERE
    d1.id# = m.rule_set_id#
    AND d2.id# = m.code_id#
    AND m.object_owner_uid# = 2147483636

View Text - HTML Formatted

SELECT D2.CODE
, D1.NAME
, U.NAME
, M.OBJECT_NAME
, M.ENABLED
, M.PRIVILEGE_SCOPE FROM DVSYS.COMMAND_RULE$ M
, DVSYS.DV$RULE_SET D1
, DVSYS.DV$CODE D2
, SYS.USER$ U WHERE D1.ID# = M.RULE_SET_ID#
AND D2.ID# = M.CODE_ID#
AND M.OBJECT_OWNER_UID# = U.USER# UNION SELECT D2.CODE
, D1.NAME
, '%'
, M.OBJECT_NAME
, M.ENABLED
, M.PRIVILEGE_SCOPE FROM DVSYS.COMMAND_RULE$ M
, DVSYS.DV$RULE_SET D1
, DVSYS.DV$CODE D2 WHERE D1.ID# = M.RULE_SET_ID#
AND D2.ID# = M.CODE_ID#
AND M.OBJECT_OWNER_UID# = 2147483636