VIEW: SYS.KU$_AUDIT_CONTEXT_VIEW

Source

View Text - Preformatted

select
  "USER",
  cast(multiset(
    select
        acn.namespace,
        cast(multiset(
          select attribute
          from aud_context$ aca
          where aca.user#=acu.user# and aca.namespace=acn.namespace
                                   ) as ku$_audit_attr_list_t)
    from ku$_audcontext_namespace_view acn where acu.user#=acn.user#
                       ) as ku$_audit_namespace_list_t)
from  ku$_audcontext_user_view acu

View Text - HTML Formatted

SELECT "USER"
, CAST(MULTISET( SELECT ACN.NAMESPACE
, CAST(MULTISET( SELECT ATTRIBUTE
FROM AUD_CONTEXT$ ACA
WHERE ACA.USER#=ACU.USER#
AND ACA.NAMESPACE=ACN.NAMESPACE ) AS KU$_AUDIT_ATTR_LIST_T)
FROM KU$_AUDCONTEXT_NAMESPACE_VIEW ACN
WHERE ACU.USER#=ACN.USER# ) AS KU$_AUDIT_NAMESPACE_LIST_T) FROM KU$_AUDCONTEXT_USER_VIEW ACU