DBA Data[Home] [Help]

VIEW: SYS.AUDITABLE_SYSTEM_ACTIONS

Source

View Text - Preformatted

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)
View Text - HTML Formatted

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)