| |
 |
|
Oracle Tips by Burleson |
Chapter 9 Oracle System Event Trigger
Auditing
-
DDL triggers -- Using the DDL trigger,
the Oracle DBA can automatically track all changes to the database
including changes to tables, indexes, and constraints. The data from
this trigger is especially useful for change control and auditing
changes to the production environment. This is especially important
for Oracle databases that are “certified” by government agencies.
While Oracle provided the functionality for
these new triggers, it was not clear how they could be used in order
to track system-wide usage. This chapter describes our work in
creating end-user log in/log off procedures to facilitate tracing
end-user activity. Please be advised that the initial
implementation of system level triggers for end-user tracking is
quite new, and as such is still a bit lacking in robust
functionality.
While the user log on/log off triggers will
accurately tell you the time of the user log on and user log off,
the code does not capture any information regarding the specific
tasks that were performed during the user's session. Also note that
these user log on and log off triggers are best used for those types
of applications that utilize time stamped users. By time stamped
users, we mean those users who are given a unique Oracle user ID
when they access the application. Applications that do not utilize
the time stamped Oracle user IDs (SAP, PeopleSoft) may not benefit
greatly by using these log on and log off triggers.
Now let's take a closer look at how these
triggers work with Oracle tables.
Database Startup
Event Triggers
Package pinning has
become a very important part of Oracle tuning. With the introduction
of system-level
The above text is
an excerpt from
the bestselling book:
Oracle
Privacy Security Auditing.
It's only $39.95 and has an
download of working security scripts:
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
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
|
|
