|
|
| |
 |
|
Oracle Tips by Burleson |
Chapter 8 General Oracle Auditing
|
COLUMN NAME |
DESCRIPTION |
|
CLIENT_ID |
The Client Identifier for that session,
which is relevant only in Oracle 9i and above. This has been
described in detail later in this chapter. |
|
SESSION_CPU |
The CPU time consumed by this session. |
The three columns referenced above have been
described in detail here.
SES_ACTIONS
– This is a long string that shows
the actions made on the object. The string is 19 characters long, of
which only the first 13 are relevant. These 13 characters represent
the result of an action on the object. For instance, the first
character is for ALTER. If this character shows S, then the object
was altered successfully. A value of F indicates a failed alter on
the object. It both success and failure results exist for the ALTER
– the character is B (for both).
The other characters represent the following
|
POSITION |
AUDITED ACTION |
|
1 |
ALTER |
|
2 |
AUDIT |
|
3 |
COMMENT |
|
4 |
DELETE |
|
5 |
GRANT |
|
6 |
INDEX |
|
7 |
INSERT |
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:
|
|
|
