Whichever one(s) have the specific data that you're interested in?
Presumably, you know what your "audit reports" are supposed to contain. Since we're not part of your company and have no context, however, it's impossible for us to guess about what sort of report you're trying to write. That makes it impossible to know which data dictionary table(s) you would need to use.
Which data dictionary is best to use to generate audit reports?
Thanks a lot,
which metric measures "best"
answer depends upon which audit details needs to be reported.
use the view that contains the details that folks want to see.
The three above are not the only choices & a join (or 2 ) may be required.
Well, that specific report sounds like it would be easiest to write against DBA_AUDIT_SESSION. Assuming that you have looked at what all three data dictionary tables contain, is there some reason that you don't believe that the obvious view is the right one? Is the auditor asking for something that is not in the view?
As others have pointed out on your multiple related threads, this will not allow you to report on the human users that logged in via a three-tier application.
I thank you all,
But when I count our sys.aud$ against dba_audit_session, sys.aud$ has more rows. So it might be that sys.aud$ is more
accurate to extract report from?
Nothing here stops you from generating a report from contents of SYS.AUD$
Please proceed to do so & stop bothering us with your daily task assignments!