Audit by session VS by access!
871977Mar 17 2012 — edited Mar 22 2012Hi all,
My Database audit_file_dest=/u01/app/oracle/admin/orcl/adump
I set:
alter system set audit_trail='XML' scope=spfile;
startup force;
audit select, insert, update on test by access;
grant connect to test identified by test;
grant select, insert, update on test to test;
And conn test/test to:
update test set max_salary=max_salary*3;
update test set max_salary=max_salary*3;
update test set max_salary=max_salary*3;
update test set max_salary=max_salary*3;
How many audit trail record will be generated? and where can i find it?
Thank you!
Edited by: Dan on Mar 16, 2012 11:42 PM