 |
|
Oracle Tips by Burleson |
Oracle 10g Audit Enhancements
Oracle databases have many types of auditing
features. In mandatory auditing, certain actions are always audited,
regardless of the other audit options or parameters. Database
activities, such as system startup and shutdown, are always
recorded.
In the standard auditing method, auditing is
set at the system level using the audit_trail initialization
parameter. Once auditing is turned on, you have the option of
selecting the objects and privileges you wish to audit.
In the fine-grained auditing (FGA) method, the
audit is based on the data content. FGA provides better control and
is a more granular method of auditing. This method creates audit
records based on the exact query, condition, and data retrieved or
manipulated by the statement. This method also provides a facility
to audit only those statements (including actual values of possible
bind-variables) that reference a particular column. The FGA method
was introduced in Oracle9i. Oracle Database 10g enhances the FGA
capability. The Extended SQL Support in FGA now supports the
granular auditing of queries, as well as UPDATE, INSERT, and DELETE
operations.
The next sections examine and discuss the new
audit features introduced in the Oracle database 10g.
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
|
