| |
 |
|
Oracle Tips by Burleson |
Chapter 10 Oracle Grants
Auditing
Table 10.3 below shows the various columns of the
view dba_audit_statement and their descriptions.
|
COLUMN |
DESCRIPTION |
|
OS_USERNAME |
The Operating System username |
|
USERNAME |
The database username |
|
USERHOST |
The host name from where the user is
connected.
|
|
TERMINAL |
The terminal number. In case of
Windows, this shows the machine name. The USERHOST column
shows nothing. |
|
TIMESTAMP |
The Timestamp when it occurred. |
|
OWNER |
The owner of the object on which the
audit occurred. |
|
OBJ_NAME |
Name of the object on which the
auditing occurred. However, this also shows non-objects such
as roles, as we will see later. |
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:
http://rampant-books.com/book_2003_2_audit.htm
|
Download your Oracle scripts now:
www.oracle-script.com
The
definitive Oracle Script collection for every Oracle professional DBA
|
|
