How to get an audit trail report
igweMar 18 2010 — edited Mar 18 2010Hello 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.