<b>Oracle 10g加强审计(一)-表insert及bind values-性能调优</b>[Oracle防范]

sys:
SQL> audit INSERT on test.a by access ;

审计已成功.

test:

SQL> INSERT INTO A VALUES(1,'10');

1 row inserted

SQL> commit;

完成后.

查抄系统审计表:

SQL> SELECT username,obj_name,sql_text FROM DBA_AUDIT_TRAIL WHERE USERNAME='TEST' and obj_name='A' AND SQL_text is not null;

USERNAME OBJ_NAME SQL_TEXT
-------------------------------------- --------------------------------------------------------------------------------
TEST A
INSERT INTO A VALUES(1,'10')

完成后,记得关闭审计

SQL> noaudit INSERT on test.a ;