||Oracle Tips by Burleson
Chapter 8 General Oracle Auditing
we did not set it. The second position, for
unsuccessful attempts, shows "S", meaning it has been set.
Another type of auditing is set for ACCESS as
on claim_schema.claims by access;
In this case the values in this column are
recorded as A, as shown in the following query:
DEPOT FOR FULL SCRIPT
and object_name = 'CLAIMS';
The result comes back as:
It shows the first letter A, for successful
attempts and the second letter A, for unsuccessful ones, exactly
like the BY SESSION option.
Table 8.5 below shows the columns of this view
and their description.
The owner of the object on which this
auditing option is set.
The name of the object.
The above text is
an excerpt from:
Oracle Privacy Security Auditing
Final Word on Oracle Security
This is the only authoritative
book on Oracle Security, Oracle Privacy, and Oracle Auditing written
by two of the world’s leading Oracle Security experts.
This indispensable book is only
and has an
immediate download of working security scripts: