DBA Data[Home] [Help]

VIEW: SYS.DBA_XS_ENB_AUDIT_POLICIES

Source

View Text - Preformatted

select enb_pol.user_name, enb_pol.policy_name, enb_pol.enabled_opt,
       enb_pol.success, enb_pol.failure
  from sys.audit_unified_enabled_policies enb_pol,
       sys.audit_unified_policies pol
 where enb_pol.policy_name = pol.policy_name and
       pol.audit_option_type='XS ACTION'
View Text - HTML Formatted

SELECT ENB_POL.USER_NAME
, ENB_POL.POLICY_NAME
, ENB_POL.ENABLED_OPT
, ENB_POL.SUCCESS
, ENB_POL.FAILURE
FROM SYS.AUDIT_UNIFIED_ENABLED_POLICIES ENB_POL
, SYS.AUDIT_UNIFIED_POLICIES POL
WHERE ENB_POL.POLICY_NAME = POL.POLICY_NAME AND POL.AUDIT_OPTION_TYPE='XS ACTION'