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!

How to get an audit trail report

igweMar 18 2010 — edited Mar 18 2010
Hello everyone, I have enabled audit trail on EBS (I'm not a DBA by the way) and now want to prepare an oracle report showing all tables for which audit trail has been enabled and what action was performed, what was changed, by who e.t.c
Problem is, for a table like PER_OBJECTIVES for instance, I may enable audit for 3 columns and do an update on only one. If audit is enabled on PER_PERSONAL_SCORECARDS it may only be for 2 columns e.t.c.
So there is a real problem in designing a report which shows changes for all tables because the columns in PER_OBJECTIVES_A are different in number from those in PER_PERSONAL_SCORECARDS_A.
I looked at this article on the web - http://www.oracle-base.com/articles/8i/Auditing.php
and it mentioned a table SYS.AUD$, my problem is, it doesn't return any rows.
Is there a table I can look to see audit changes in a more report friendly format for all tables?
Thanks a lot.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 15 2010
Added on Mar 18 2010
2 comments
1,017 views