 |
|
Oracle Tips by Burleson |
Chapter 11 Oracle Fine Grained Auditing
--
*********************************************
set linesize 4000
set trimspool on
set pagesize 0
set feedback off
spool show_fga_fb.sql
select
'prompt DBSUSER:'||db_user||
' OSUSER:'||os_user||
' TIMESTAMP:'||timestamp hdr,
'select * from ('||sql_text||
') as of scn ('||scn||');' stmt
from dba_fga_audit_trail
/
spool off
prompt Now run the script show_fga_fb.sql
Running the script show_fga_fb.sql produces a
result similar to the following.
DBSUSER:CLAIM_SCHEMA OSUSER:ananda
TIMESTAMP:18-AUG-03
1 123456789 12345 1234567 1700 1700 P
2 234567891 12345 1234567 2300 1700 P
3 234567891 12345 2345678 1900 1800 P
DBSUSER:SECUSER OSUSER:ananda TIMESTAMP:18-AUG-03
1 123456789 12345 1234567 1700 1700 P
2 234567891 12345 1234567 2300 1700 P
3 234567891 12345 2345678 1900 1800 P
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
|
|