select audit_type, component, command_type, command_name from
(select distinct audit_type, component from v$unified_audit_record_format
where component = 'Standard'),
v$sqlcommand
where command_type NOT IN (0, 27, 34, 57, 87, 89, 203, 204, 209, 210,
211, 213, 17, 18, 30, 31, 47, 189)
UNION ALL
select audit_type, component, action, name from
(select distinct audit_type, component from v$unified_audit_record_format
where component = 'Standard'),
(select 17 action, 'GRANT' name from dual UNION ALL
select 18 action, 'REVOKE' name from dual UNION ALL
select 30 action, 'AUDIT' name from dual UNION ALL
select 31 action, 'NOAUDIT' name from dual UNION ALL
select 100 action, 'LOGON' name from dual UNION ALL
select 101 action, 'LOGOFF' name from dual UNION ALL
select 47 action, 'EXECUTE' name from dual UNION ALL
select 189 action, 'MERGE' name from dual UNION ALL
select (select max(command_type) from v$sqlcommand)+1 action,
'ALL' name from dual)
/* 2. Add OLS audit actions */
UNION ALL
select audit_type, component, indx, action_name from
(select distinct audit_type, component from v$unified_audit_record_format
where component = 'Label Security'),
(select indx, action_name from x$aud_ols_actions where indx <> 0)
/* 3. Add Triton audit actions */
UNION ALL
select audit_type, component, indx, action_name from
(select distinct audit_type, component from v$unified_audit_record_format
where component = 'XS'),
(select indx, action_name from x$aud_xs_actions where indx <> 0)
/* 5. Add Data Pump audit actions */
UNION ALL
select audit_type, component, indx, action_name from
(select distinct audit_type, component from v$unified_audit_record_format
where component = 'Datapump'),
(select indx, action_name from x$aud_dp_actions where indx <> 0)
/* 6. Add Database Vault audit actions */
UNION ALL
select audit_type, component, indx, action_name from
(select distinct audit_type, component from v$unified_audit_record_format
where component = 'Database Vault'),
(select indx, action_name from x$aud_dv_obj_events where indx <> 0)
/* 7. Add Direct path API audit actions */
UNION ALL
select audit_type, component, indx, action_name from
(select distinct audit_type, component from v$unified_audit_record_format
where component = 'Direct path API'),
(select indx, action_name from x$aud_dpapi_actions where indx <> 0)
SELECT AUDIT_TYPE
, COMPONENT
, COMMAND_TYPE
, COMMAND_NAME FROM
(SELECT DISTINCT AUDIT_TYPE
, COMPONENT
FROM V$UNIFIED_AUDIT_RECORD_FORMAT
WHERE COMPONENT = 'STANDARD')
,
V$SQLCOMMAND
WHERE COMMAND_TYPE NOT IN (0
, 27
, 34
, 57
, 87
, 89
, 203
, 204
, 209
, 210
,
211
, 213
, 17
, 18
, 30
, 31
, 47
, 189)
UNION ALL
SELECT AUDIT_TYPE
, COMPONENT
, ACTION
, NAME FROM
(SELECT DISTINCT AUDIT_TYPE
, COMPONENT
FROM V$UNIFIED_AUDIT_RECORD_FORMAT
WHERE COMPONENT = 'STANDARD')
,
(SELECT 17 ACTION
, 'GRANT' NAME
FROM DUAL UNION ALL
SELECT 18 ACTION
, 'REVOKE' NAME
FROM DUAL UNION ALL
SELECT 30 ACTION
, 'AUDIT' NAME
FROM DUAL UNION ALL
SELECT 31 ACTION
, 'NOAUDIT' NAME
FROM DUAL UNION ALL
SELECT 100 ACTION
, 'LOGON' NAME
FROM DUAL UNION ALL
SELECT 101 ACTION
, 'LOGOFF' NAME
FROM DUAL UNION ALL
SELECT 47 ACTION
, 'EXECUTE' NAME
FROM DUAL UNION ALL
SELECT 189 ACTION
, 'MERGE' NAME
FROM DUAL UNION ALL
SELECT (SELECT MAX(COMMAND_TYPE)
FROM V$SQLCOMMAND)+1 ACTION
,
'ALL' NAME
FROM DUAL)
/* 2. ADD OLS AUDIT ACTIONS */
UNION ALL
SELECT AUDIT_TYPE
, COMPONENT
, INDX
, ACTION_NAME FROM
(SELECT DISTINCT AUDIT_TYPE
, COMPONENT
FROM V$UNIFIED_AUDIT_RECORD_FORMAT
WHERE COMPONENT = 'LABEL SECURITY')
,
(SELECT INDX
, ACTION_NAME
FROM X$AUD_OLS_ACTIONS
WHERE INDX <> 0)
/* 3. ADD TRITON AUDIT ACTIONS */
UNION ALL
SELECT AUDIT_TYPE
, COMPONENT
, INDX
, ACTION_NAME FROM
(SELECT DISTINCT AUDIT_TYPE
, COMPONENT
FROM V$UNIFIED_AUDIT_RECORD_FORMAT
WHERE COMPONENT = 'XS')
,
(SELECT INDX
, ACTION_NAME
FROM X$AUD_XS_ACTIONS
WHERE INDX <> 0)
/* 5. ADD DATA PUMP AUDIT ACTIONS */
UNION ALL
SELECT AUDIT_TYPE
, COMPONENT
, INDX
, ACTION_NAME FROM
(SELECT DISTINCT AUDIT_TYPE
, COMPONENT
FROM V$UNIFIED_AUDIT_RECORD_FORMAT
WHERE COMPONENT = 'DATAPUMP')
,
(SELECT INDX
, ACTION_NAME
FROM X$AUD_DP_ACTIONS
WHERE INDX <> 0)
/* 6. ADD DATABASE VAULT AUDIT ACTIONS */
UNION ALL
SELECT AUDIT_TYPE
, COMPONENT
, INDX
, ACTION_NAME FROM
(SELECT DISTINCT AUDIT_TYPE
, COMPONENT
FROM V$UNIFIED_AUDIT_RECORD_FORMAT
WHERE COMPONENT = 'DATABASE VAULT')
,
(SELECT INDX
, ACTION_NAME
FROM X$AUD_DV_OBJ_EVENTS
WHERE INDX <> 0)
/* 7. ADD DIRECT PATH API AUDIT ACTIONS */
UNION ALL
SELECT AUDIT_TYPE
, COMPONENT
, INDX
, ACTION_NAME FROM
(SELECT DISTINCT AUDIT_TYPE
, COMPONENT
FROM V$UNIFIED_AUDIT_RECORD_FORMAT
WHERE COMPONENT = 'DIRECT PATH API')
,
(SELECT INDX
, ACTION_NAME
FROM X$AUD_DPAPI_ACTIONS
WHERE INDX <> 0)
|
|
|