| |
 |
|
Oracle Tips by Burleson |
Chapter 9 Oracle System Event Trigger
Auditing
Here is the listing from the user_sum_rpt.sql
report.
user_sum_rpt.sql
--**********************************************
--
-- Copyright © 2003 by Rampant TechPress Inc.
--
-- Free for non-commercial use.
-- For commercial licensing, e-mail info@rampant.cc
--
-- *********************************************
connect perfstat/perfstat;
set pages 999;
set lines 80;
alter session set nls_date_format='YY-MM-DD hh24:mi';
column TOTAL_MINUTES Heading 'Total|Minutes' format 9,999
column DAY Heading 'Day' format a10
break on day skip 2
select
to_char(logoff_day,'YYYY-MM-DD') day,
user_id,
round(sum(elapsed_minutes)) total_minutes
from
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
|
