|
 |
|
Oracle Tips by Burleson |
Chapter 9 Oracle System Event Trigger
Auditing
Introduction
Some of the most exciting new features within
Oracle are the new system-level triggers that were introduced in
Oracle8i. What is truly exciting is that we can combine the
system-level triggers with STATSPACK extension tables, thereby
building a mechanism that will give complete auditing information on
user logon and logoff, DDL, and server errors.
Just as an Oracle trigger fires on a specific
DM event, system-level triggers are fired at specific system events
such as logon, logoff, database startup, DDL execution, and
servererror triggers:
-
Database startup triggers - Database startup
triggers can be used to invoke the dbms_shared_pool.keep procedure
to pin all frequently referenced PL/SQL packages into RAM.
-
Logon triggers - The logon triggers can be used
to store login information directly inside Oracle tables, thereby
providing a complete audit of when users enter your system.
-
Logoff triggers -- Oracle logoff triggers can
automatically capture elapsed session duration times for all users
who have accessed your Oracle database.
-
Servererror triggers -- With the servererror
trigger, the Oracle administrator can automatically log all serious
PL/SQL errors into an Oracle STATSPACK extension table. This table,
in turn, has an insert trigger that e-mails the server error to the
DBA for immediate notification.
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
|
|