 |
|
Oracle Tips by Burleson |
Oracle 10g Fine-Grained Auditing (FGA)
In general, the FGA method of auditing monitors
the data access based on the information retrieved or modified by
the query or DML. With the help of the FGA method, it becomes easier
to focus on security-relevant columns and rows and ignore areas that
are less important. Another advantage with the FGA method is that it
produces far less audit records, while being more useful in keeping
a safe security track.
The FGA method was introduced in Oracle9i
Enterprise Edition. However, this method provided only support for
the ‘SELECT’ statements. With Oracle Database 10g, it becomes
possible to extend the FGA method to cover UPDATE, INSERT, and
DELETE statements as well.
FGA helps in detecting the potential misuse of
user privileges and possible security breaches, without having to
make changes in the actual application code. With the help of FGA
event handlers, policy violations may generate notifications to
alert the administrators.
We have covered more details on the topic of
FGA in Chapter 15, Security Enhancements.
Get the complete Oracle10g story:
To get the code instantly, click here:
Need an Oracle Mentor?
BEI is now offering personal mentors for Oracle DBAs where you can have an
Oracle expert right at your fingertips, anytime day or night. We work with
hundreds of Oracle databases every year, so we know exactly how to quickly
assist you with any Oracle question.
Why risk an unplanned outage? You can now get telephone access to Don
Burleson or any of his Oracle Certified DBAs with more than 20 years of
full-time IT experience. Click here for details:
http://www.dba-oracle.com/service_oracle_backup.htm
|
