| |
 |
|
Oracle Tips by Burleson |
Chapter 9 Oracle System Event Trigger
Auditing
-- Copyright
© 2003 by Rampant TechPress Inc.
--
-- Free for
non-commercial use.
-- For
commercial licensing, e-mail info@rampant.cc
--
--
*********************************************
connect
sys/manager as sysdba
create table
stats$user_log
(
user_id
varchar2(30),
session_id
number(8),
host varchar2(30),
last_program varchar2(48),
last_action varchar2(32),
last_module varchar2(32),
logon_day
date,
logon_time
varchar2(10),
logoff_day
date,
logoff_time varchar2(10),
elapsed_minutes number(8)
)
tablespace
perfstat
;
Designing a log on
trigger
Once the table is designed, the next task is to
create a system level log on trigger that will fill in as much
information as possible at the time of the log on event. The code
above illustrates the log on audit trigger that we created. As you
can see, we populate this table with three values that are available
at log on time:
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
|
