 |
|
Oracle Tips by Burleson |
Chapter 8 General Oracle Auditing
The view shows the audit options set for the
object, one column per each type of statement. For instance, if we
decide to audit all ALTER statements on table CLAIMS owned user
CLAIM_SCHEMA, we would issue:
AUDIT ALTER
ON CLAIM_SCHEMA.CLAIMS BY SESSION;
After this, we can see what audit options exist
for this object by issuing:
select ALT
from dba_obj_audit_opts
SEE CODE
DEPOT FOR FULL SCRIPT
and object_name = 'CLAIMS';
The result comes back as:
ALT
---
S/S
Note the column name, ALT, that signifies the
audit options for the ALTER statements on the object. A separate
column exists for each of the statements. A complete list is
provided in Table 8.5, where the columns of this view have been
described.
Note the value is shown as "S/S". It means that
the options are set to record the statement when the statement is
successful (the letter S in the first position) and unsuccessful
(the other letter S in the second position). Since we did not
specify which to audit, the default of both was applied.
The above text is
an excerpt from:
Oracle Privacy Security Auditing
The
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
$39.95
and has an
immediate download of working security scripts:
|
