|
|
Oracle Tips by Burleson |
Chapter 11 Oracle Fine Grained Auditing
set trimspool
on
set pagesize 0
set feedback off
spool show_fga_fb.sql
select 'select * from ('||lsqltext||') as of scn ('||scn||');'
from fga_log$
/
spool off
This creates a file show_fga_fb.sql with lines
similar to the following.
select * from
(select * from claim_Schema.claims) as of scn 1852891500;
The file show_fga_fb.sql can then be run to
retrieve the values of columns as of a date in the past.
Another variation in the setup can be to
include all other relevant details like username, OS username,
terminal, timestamp, etc. along with the data selected from the
tables. The following query accomplishes the task. If desired, all
the relevant details can be placed as needed in the script.
cr_show_fga_fb.sql
--**********************************************
--
-- Copyright © 2003 by Rampant TechPress Inc.
--
-- Free for non-commercial use.
-- For commercial licensing, e-mail info@rampant.cc
--
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
|
|