Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

AUDIT Confusion

845641Nov 25 2011 — edited Nov 25 2011
I am on 11g R2 Linun redhat-5 , i found a strange thing today, i fired audit all on scott.emp by session but when when i see dba_Audit_Trail it is showing me everytime time the command is executed, means if command select * from emp is executed as scott 5 times it is showing me 5 times the rows in dba_Audit_trail, just like by access option. Note i have not executed audit all on scott.emp by access. I just said audit all on scott.emp by session means it should be audit once even if i execute 10 times
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 23 2011
Added on Nov 25 2011
2 comments
394 views