| |
 |
|
Oracle Tips by Burleson |
Chapter 9 Oracle System Event Trigger
Auditing
--
***************************************************
update
stats$user_log
set
last_module =
(select module from v$session where
sys_context('USERENV','SESSIONID') = audsid)
SEE CODE
DEPOT FOR FULL SCRIPT
--
***************************************************
-- Update the
logoff day
--
***************************************************
update
stats$user_log
set
logoff_day
= sysdate
SEE CODE
DEPOT FOR FULL SCRIPT
--
***************************************************
-- Update the
logoff time
--
***************************************************
update
stats$user_log
set
logoff_time = to_char(sysdate, 'hh24:mi:ss')
SEE CODE
DEPOT FOR FULL SCRIPT
--
***************************************************
-- Compute
the elapsed minutes
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
|
