首页 娱乐综艺正文

ORACLE 19C 统一审计线索表定义

qiandu 综艺 2021-09-13 15:44:33 3 0

createtableAUDSYS.AUD$UNIFIED

(

inst_idNUMBER,

audit_typeNUMBER,

sessionidNUMBER,

proxy_sessionidNUMBER,

os_userVARCHAR2(128),

host_nameVARCHAR2(128),

terminalVARCHAR2(30),

instance_idNUMBER,

dbidNUMBER,

authentication_typeVARCHAR2(1024),

useridVARCHAR2(128),

proxy_useridVARCHAR2(128),

external_useridVARCHAR2(1024),

global_useridVARCHAR2(32),

client_program_nameVARCHAR2(48),

dblink_infoVARCHAR2(4000),

xs_user_nameVARCHAR2(128),

xs_sessionidRAW(33),

entry_idNUMBERnotnull,

statement_idNUMBERnotnull,

event_timestampTIMESTAMP(6)notnull,

actionNUMBERnotnull,

return_codeNUMBERnotnull,

os_processVARCHAR2(16),

transaction_idRAW(8),

scnNUMBER,

execution_idVARCHAR2(64),

obj_ownerVARCHAR2(128),

obj_nameVARCHAR2(128),

sql_textCLOB,

sql_bindsCLOB,

application_contextsVARCHAR2(4000),

client_identifierVARCHAR2(64),

new_ownerVARCHAR2(128),

new_nameVARCHAR2(128),

object_editionVARCHAR2(128),

system_privilege_usedVARCHAR2(1024),

system_privilegeNUMBER,

audit_optionNUMBER,

object_privilegesVARCHAR2(35),

roleVARCHAR2(128),

target_userVARCHAR2(128),

excluded_userVARCHAR2(128),

excluded_schemaVARCHAR2(128),

excluded_objectVARCHAR2(128),

current_userVARCHAR2(128),

additional_infoVARCHAR2(4000),

unified_audit_policiesVARCHAR2(4000),

fga_policy_nameVARCHAR2(128),

xs_inactivity_timeoutNUMBER,

xs_entity_typeVARCHAR2(32),

xs_target_principal_nameVARCHAR2(128),

xs_proxy_user_nameVARCHAR2(128),

xs_datasec_policy_nameVARCHAR2(128),

xs_schema_nameVARCHAR2(128),

xs_callback_event_typeVARCHAR2(32),

xs_package_nameVARCHAR2(128),

xs_procedure_nameVARCHAR2(128),

xs_enabled_roleVARCHAR2(128),

xs_cookieVARCHAR2(1024),

xs_ns_nameVARCHAR2(128),

xs_ns_attributeVARCHAR2(4000),

ORACLE 19C 统一审计线索表定义

xs_ns_attribute_old_valVARCHAR2(4000),

xs_ns_attribute_new_valVARCHAR2(4000),

dv_action_codeNUMBER,

dv_action_nameVARCHAR2(30),

dv_extended_action_codeNUMBER,

dv_granteeVARCHAR2(128),

dv_return_codeNUMBER,

dv_action_object_nameVARCHAR2(128),

dv_rule_set_nameVARCHAR2(90),

dv_commentVARCHAR2(4000),

dv_factor_contextVARCHAR2(4000),

dv_object_statusVARCHAR2(1),

ols_policy_nameVARCHAR2(128),

ols_granteeVARCHAR2(128),

ols_max_read_labelVARCHAR2(4000),

ols_max_write_labelVARCHAR2(4000),

ols_min_write_labelVARCHAR2(4000),

ols_privileges_grantedVARCHAR2(128),

ols_program_unit_nameVARCHAR2(128),

ols_privileges_usedVARCHAR2(128),

ols_string_labelVARCHAR2(4000),

ols_label_component_typeVARCHAR2(12),

ols_label_component_nameVARCHAR2(30),

ols_parent_group_nameVARCHAR2(30),

ols_old_valueVARCHAR2(4000),

ols_new_valueVARCHAR2(4000),

rman_session_recidNUMBER,

rman_session_stampNUMBER,

rman_operationVARCHAR2(20),

rman_object_typeVARCHAR2(20),

rman_device_typeVARCHAR2(5),

dp_text_parameters1VARCHAR2(512),

dp_boolean_parameters1VARCHAR2(512),

direct_path_num_columns_loadedNUMBER,

rls_infoCLOB,

ksacl_user_nameVARCHAR2(128),

ksacl_service_nameVARCHAR2(512),

ksacl_source_locationVARCHAR2(48),

con_idNUMBER,

protocol_session_idNUMBER,

protocol_return_codeNUMBER,

protocol_action_nameVARCHAR2(32),

protocol_userhostVARCHAR2(128),

protocol_messageVARCHAR2(4000)

)

partitionbyrange(EVENT_TIMESTAMP)

(

partitionSYS_P348valueslessthan(TIMESTAMP'2021-06-0100:00:00')

tablespaceSYSAUX

pctfree10

initrans1

maxtrans255

storage

(

initial64K

next1M

minextents1

maxextentsunlimited

)

);

--Addcommentstothetable

commentontableAUDSYS.AUD$UNIFIED

is'UnifiedAuditinternaltable,whichholdstheunifiedauditrecords';

版权声明

本文仅代表作者观点,不代表本站立场。
本文系作者授权发表,未经许可,不得转载。

本文链接:http://lczshcp.com/post/11652.html