oracle数据库审计功能(二)
AL;
TO_CHAR(DBMS_METADATA.GET_DDL('TABLE','AUD$'))
--------------------------------------------------------------------------------
CREATE TABLE "SYS"."AUD$"
( "SESSIONID" NUMBER NOT NULL ENABLE,
"ENTRYID" NUMBER NOT NULL ENABLE,
"STATEMENT" NUMBER NOT NULL ENABLE,
"TIMESTAMP#" DATE,
"USERID" VARCHAR2(30),
"USERHOST" VARCHAR2(128),
"TERMINAL" VARCHAR2(255),
"ACTION#" NUMBER NOT NULL ENABLE,
"RETURNCODE" NUMBER NOT NULL ENABLE,
"OBJ$CREATOR" VARCHAR2(30),
"OBJ$NAME" VARCHAR2(128),
"AUTH$PRIVILEGES" VARCHAR2(16),
"AUTH$GRANTEE" VARCHAR2(30),
"NEW$OWNER" VARCHAR2(30),
"NEW$NAME" VARCHAR2(128),
"SES$ACTIONS" VARCHAR2(19),
"SES$TID" NUMBER,
"LOGOFF$LREAD" NUMBER,
"LOGOFF$PREAD" NUMBER,
"LOGOFF$LWRITE" NUMBER,
"LOGOFF$DEAD" NUMBER,
"LOGOFF$TIME" DATE,
"COMMENT$TEXT" VARCHAR2(4000),
"CLIENTID" VARCHAR2(64),
"SPARE1" VARCHAR2(255),
"SPARE2" NUMBER,
"OBJ$LABEL" RAW(255),
"SES$LABEL" RAW(255),
"PRIV$USED" NUMBER,
"SESSIONCPU" NUMBER,
"NTIMESTAMP#" TIMESTAMP (6),
"PROXY$SID" NUMBER,
"USER$GUID" VARCHAR2(32),
"INSTANCE#" NUMBER,
"PROCESS#" VARCHAR2(16),
"XID" RAW(8),
"AUDITID" VARCHAR2(64),
"SCN" NUMBER,
"DBID" NUMBER,
"SQLBIND" CLOB,
"SQLTEXT" CLOB,
"OBJ$EDITION" VARCHAR2(30)
) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DE
FAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "SYSTEM"
LOB ("SQLBIND") STORE AS BASICFILE (
TABLESPACE "SYSTEM" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION
NOCACHE LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DE
FAULT CELL_FLASH_CACHE DEFAULT))
LOB ("SQLTEXT") STORE AS BASICFILE (
TABLESPACE "SYSTEM" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION
NOCACHE LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DE
FAULT CELL_FLASH_CACHE DEFAULT))
SQL>
SQL> CREATE TABLE sys.AUD$_ARCH
2 ( SESSIONID NUMBER NOT NULL ENABLE,
3 ENTRYID NUMBER NOT NULL ENABLE,
4 STATEMENT NUMBER NOT NULL ENABLE,
5 TIMESTAMP# DATE,
6 USERID VARCHAR2(30),
7 USERHOST VARCHAR2(128),
8 TERMINAL VARCHAR2(255),
9 ACTION# NUMBER NOT NULL ENABLE,
10 RETURNCODE NUMBER NOT NULL ENABLE,
11 OBJ$CREATOR VARCHAR2(30),
12 OBJ$NAME VARCHAR2(128),
13 AUTH$PRIVILEGES VARCHAR2(16),
14 AUTH$GRANTEE VARCHAR2(30),
15 NEW$OWNER VARCHAR2(30),
16 NEW$NAME VARCHAR2(128),
SES$ACTIONS VARCHAR2(19),
17 18 SES$TID NUMBER,
19 LOGOFF$LREAD NUMBER,
20 LOGOFF$PREAD NUMBER,
21 LOGOFF$LWRITE NUMBER,
22 LOGOFF$DEAD NUMBER,
23 LOGOFF$TIME DATE,
24 COMMENT$TEXT VARCHAR2(4000),
25 CLIENTID VARCHAR2(64),
26 SPARE1 VARCHAR2(255),
27 SPARE2 NUMBER,
28 OBJ$LABEL RAW(255),
29 SES$LABEL RAW(255),
30 PRIV$USED NUMBER,
31 SESSIONCPU NUMBER,
32 NTIMESTAMP# TIMESTAMP (6),
33 PROXY$SID NUMBER,
34 USER$GUID VARCHAR2(32),
35 INSTANCE# NUMBER,
36 PROCESS# VARCHAR2(16),
37 XID RAW(8),
38 AUDITID VARCHAR2(64),
39 SCN NUMBER,
40 DBID NUMBER,
41 SQLBIND CLOB,
42 SQLTEXT CLOB,
43 OBJ$EDITION VARCHAR2(30)
44 )
45