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'
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'
|
|
|