I'm hoping someone can give me a sanity check here. :)
I have a canned report I've been providing to auditors and part of it queries
DBA_STMT_AUDIT_OPTS and DBA_PRIV_AUDIT_OPTS. But these are not populated in
12c if unified auditing is enabled, which it is by default. Although I am
using mixed mode, so was kind of expecting to see results in these views anyway
based on the documentation.
So I opened a SR with Oracle and have been told that since I have not
explicitly issued audit statements, these views would not be populated,
regardless of the version of the database (I'm using 11.2.0.4 and 12.1.0.2).
But I'm quite certain that no one explicitly issued audit statements in the 11g
version of the database and yet these views are populated. So I'm thinking
that 11g audited statements and privileges by default and 12c does not. Am I
way off base?
Thanks,
Steve Givens
Lead Database Administrator
First National Bank
201 N 16th St, Stop Code 2252
Omaha, NE 68197
Office: 402-602-7812
sgivens@xxxxxxxx