 |
|
Oracle Tips by Burleson |
Chapter 11 Oracle Fine Grained Auditing
describe how to use this powerful tool to solve
this immediate problem.
From the FGA Audit Trails, we know that the
audit trails were triggered when the System Change Number (SCN) was
1852891500. To find out all the columns of the claims at that time,
we will simply issue:
select *
from claim_schema.claims as of scn 1852891500
SEE CODE DEPOT FOR FULL SCRIPT
This query selects the records as of SCN
1852891500, not as of now. It will let us know the value of the
different columns of that particular claim at the time the user
selected the data and the audit record was generated. This will tell
us exactly what we want to know.
However, to have a more practical use of the
clause in FGA, we will handle it differently. From the Audit Tables,
either dba_fga_audit_trail, or the
user-defined fga_audit, the following record is seen.
SCN USERNAME
----------
--------------------------------------------
SQL_TEXT
-------------------------------------------------------
1553620 CLAIM_SCHEMA
select paid_amount from claims where member_id
= 12345
It shows that
the user issued the mentioned statement while the SCN was 1553620,
and the object referenced
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
|
|
