给你个基本的思路,自己具体测试一下:一. 修改初始化参数AUDIT_TRAIL=DB 二. 打开对象审计功能 SQL>AUDIT SELECT, UPDATE, INSERT, DELETE ON STUDENT; 三. 执行对STUDENT表的操作 四. 查询DBA_AUDIT_TRAIL表,查看审计情况,其中一个关键的SES_ACTIONS字段的解释为:Session summary (a string of 16 characters, one for each action type in the order ALTER, AUDIT, COMMENT, DELETE, GRANT, INDEX, INSERT, LOCK, RENAME, SELECT, UPDATE, REFERENCES, and EXECUTE. Positions 14, 15, and 16 are reserved for future use. The characters are: - - None S - Success F - Failure B - Both五. 关闭审计 SQL>NOAUDIT SELECT, UPDATE, INSERT, DELETE ON STUDENT;相关内容见: http://hi.baidu.com/%C8%FD%B7%C9%D4%C6/blog/item/75e2818ba06fc1789f2fb4c1.html
二. 打开对象审计功能
SQL>AUDIT SELECT, UPDATE, INSERT, DELETE ON STUDENT;
三. 执行对STUDENT表的操作
四. 查询DBA_AUDIT_TRAIL表,查看审计情况,其中一个关键的SES_ACTIONS字段的解释为:Session summary (a string of 16 characters, one for each action type in the order ALTER, AUDIT, COMMENT, DELETE, GRANT, INDEX, INSERT, LOCK, RENAME, SELECT, UPDATE, REFERENCES, and EXECUTE. Positions 14, 15, and 16 are reserved for future use. The characters are:
- - None
S - Success
F - Failure
B - Both五. 关闭审计
SQL>NOAUDIT SELECT, UPDATE, INSERT, DELETE ON STUDENT;相关内容见:
http://hi.baidu.com/%C8%FD%B7%C9%D4%C6/blog/item/75e2818ba06fc1789f2fb4c1.html
http://download.oracle.com/docs/cd/B28359_01/server.111/b28286/statements_4007.htm#i2059073