VIEW: DVSYS.DV$REALM_AUTH

Source

View Text - Preformatted

SELECT
      m.id#
    , m.realm_id#
    , d1.name
    , u.name
    , m.auth_rule_set_id#
    , d2.name
    , m.auth_options
    , c.value
    , m.version
    , m.created_by
    , m.create_date
    , m.updated_by
    , m.update_date
FROM dvsys.realm_auth$ m
    , dvsys.dv$realm d1
    , dvsys.dv$rule_set d2
    , dvsys.dv$code c
    , sys.user$ u
WHERE
    d1.id# (+)= m.realm_id#
    AND d2.id# (+)= m.auth_rule_set_id#
    AND c.code_group (+) = 'REALM_OPTION'
    AND c.code (+) = TO_CHAR(m.auth_options)
    AND m.grantee_uid# = u.user#

View Text - HTML Formatted

SELECT M.ID#
, M.REALM_ID#
, D1.NAME
, U.NAME
, M.AUTH_RULE_SET_ID#
, D2.NAME
, M.AUTH_OPTIONS
, C.VALUE
, M.VERSION
, M.CREATED_BY
, M.CREATE_DATE
, M.UPDATED_BY
, M.UPDATE_DATE FROM DVSYS.REALM_AUTH$ M
, DVSYS.DV$REALM D1
, DVSYS.DV$RULE_SET D2
, DVSYS.DV$CODE C
, SYS.USER$ U WHERE D1.ID# (+)= M.REALM_ID#
AND D2.ID# (+)= M.AUTH_RULE_SET_ID#
AND C.CODE_GROUP (+) = 'REALM_OPTION'
AND C.CODE (+) = TO_CHAR(M.AUTH_OPTIONS)
AND M.GRANTEE_UID# = U.USER#