重庆思庄Oracle、Redhat认证学习论坛

标题: ORACLE 19C 统一审计线索表定义 [打印本页]

作者: 郑全 时间: 2021-5-30 19:15
标题: ORACLE 19C 统一审计线索表定义
create table AUDSYS.AUD$UNIFIED
(
  inst_id                      NUMBER,
  audit_type                   NUMBER,
  sessionid                   NUMBER,
  proxy_sessionid             NUMBER,
  os_user                      VARCHAR2(128),
  host_name                   VARCHAR2(128),
  terminal                      VARCHAR2(30),
  instance_id                   NUMBER,
  dbid                         NUMBER,
  authentication_type          VARCHAR2(1024),
  userid                      VARCHAR2(128),
  proxy_userid                VARCHAR2(128),
  external_userid             VARCHAR2(1024),
  global_userid                VARCHAR2(32),
  client_program_name          VARCHAR2(48),
  dblink_info                   VARCHAR2(4000),
  xs_user_name                VARCHAR2(128),
  xs_sessionid                RAW(33),
  entry_id                      NUMBER not null,
  statement_id                NUMBER not null,
  event_timestamp             TIMESTAMP(6) not null,
  action                      NUMBER not null,
  return_code                   NUMBER not null,
  os_process                   VARCHAR2(16),
  transaction_id                RAW(8),
  scn                         NUMBER,
  execution_id                VARCHAR2(64),
  obj_owner                   VARCHAR2(128),
  obj_name                      VARCHAR2(128),
  sql_text                      CLOB,
  sql_binds                   CLOB,
  application_contexts          VARCHAR2(4000),
  client_identifier             VARCHAR2(64),
  new_owner                   VARCHAR2(128),
  new_name                      VARCHAR2(128),
  object_edition                VARCHAR2(128),
  system_privilege_used       VARCHAR2(1024),
  system_privilege             NUMBER,
  audit_option                NUMBER,
  object_privileges             VARCHAR2(35),
  role                         VARCHAR2(128),
  target_user                   VARCHAR2(128),
  excluded_user                VARCHAR2(128),
  excluded_schema             VARCHAR2(128),
  excluded_object             VARCHAR2(128),
  current_user                VARCHAR2(128),
  additional_info             VARCHAR2(4000),
  unified_audit_policies       VARCHAR2(4000),
  fga_policy_name             VARCHAR2(128),
  xs_inactivity_timeout       NUMBER,
  xs_entity_type                VARCHAR2(32),
  xs_target_principal_name    VARCHAR2(128),
  xs_proxy_user_name          VARCHAR2(128),
  xs_datasec_policy_name       VARCHAR2(128),
  xs_schema_name                VARCHAR2(128),
  xs_callback_event_type       VARCHAR2(32),
  xs_package_name             VARCHAR2(128),
  xs_procedure_name             VARCHAR2(128),
  xs_enabled_role             VARCHAR2(128),
  xs_cookie                   VARCHAR2(1024),
  xs_ns_name                   VARCHAR2(128),
  xs_ns_attribute             VARCHAR2(4000),
  xs_ns_attribute_old_val       VARCHAR2(4000),
  xs_ns_attribute_new_val       VARCHAR2(4000),
  dv_action_code                NUMBER,
  dv_action_name                VARCHAR2(30),
  dv_extended_action_code       NUMBER,
  dv_grantee                   VARCHAR2(128),
  dv_return_code                NUMBER,
  dv_action_object_name       VARCHAR2(128),
  dv_rule_set_name             VARCHAR2(90),
  dv_comment                   VARCHAR2(4000),
  dv_factor_context             VARCHAR2(4000),
  dv_object_status             VARCHAR2(1),
  ols_policy_name             VARCHAR2(128),
  ols_grantee                   VARCHAR2(128),
  ols_max_read_label          VARCHAR2(4000),
  ols_max_write_label          VARCHAR2(4000),
  ols_min_write_label          VARCHAR2(4000),
  ols_privileges_granted       VARCHAR2(128),
  ols_program_unit_name       VARCHAR2(128),
  ols_privileges_used          VARCHAR2(128),
  ols_string_label             VARCHAR2(4000),
  ols_label_component_type    VARCHAR2(12),
  ols_label_component_name    VARCHAR2(30),
  ols_parent_group_name       VARCHAR2(30),
  ols_old_value                VARCHAR2(4000),
  ols_new_value                VARCHAR2(4000),
  rman_session_recid          NUMBER,
  rman_session_stamp          NUMBER,
  rman_operation                VARCHAR2(20),
  rman_object_type             VARCHAR2(20),
  rman_device_type             VARCHAR2(5),
  dp_text_parameters1          VARCHAR2(512),
  dp_boolean_parameters1       VARCHAR2(512),
  direct_path_num_columns_loaded NUMBER,
  rls_info                      CLOB,
  ksacl_user_name             VARCHAR2(128),
  ksacl_service_name          VARCHAR2(512),
  ksacl_source_location       VARCHAR2(48),
  con_id                      NUMBER,
  protocol_session_id          NUMBER,
  protocol_return_code          NUMBER,
  protocol_action_name          VARCHAR2(32),
  protocol_userhost             VARCHAR2(128),
  protocol_message             VARCHAR2(4000)
)
partition by range (EVENT_TIMESTAMP)
(
  partition SYS_P348 values less than (TIMESTAMP' 2021-06-01 00:00:00')
tablespace SYSAUX
pctfree 10
initrans 1
maxtrans 255
storage
(
   initial 64K
   next 1M
   minextents 1
   maxextents unlimited
)
);
-- Add comments to the table
comment on table AUDSYS.AUD$UNIFIED
  is 'Unified Audit internal table, which holds the unified audit records';

欢迎光临重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/)