DBA Data[Home] [Help]

VIEW: DVSYS.DBA_DV_ROLE

Source

View Text - Preformatted

SELECT
      m.role
    , d.name
    , m.enabled
FROM dvsys.role$ m, dvsys.dv$rule_set d
WHERE m.rule_set_id# = d.id#
View Text - HTML Formatted

SELECT M.ROLE
, D.NAME
, M.ENABLED FROM DVSYS.ROLE$ M
, DVSYS.DV$RULE_SET D WHERE M.RULE_SET_ID# = D.ID#