What is Fine Grained Auditing?
In Oracle an administrators can configure systems to audit any object, privilege, or type of statement, and the database can also audit the individual SQL statements inside of PL/SQL packages. Audit records show both operation performed and attempted–that is, for example, a record of a select, whether or not it was successful. Oracle Fine Grained(OFG) Auditing is way to make auditing more efficient by capturing relevant records and disregarding irrelevant ones. Using OFG auditing you can simply attach an audit policy to a table or view and specify your audit condition using a SQL predicatedefine At fetch time, whenever the policy condition is met for a returned row, the query is audited. Use the package DBMS_FGA to set your audit condition and specify the audit column to designate which column within a table or view requires monitoring. When the condition is met on the particular column, Oracle9i fine-grained auditing writes an audit record that shows the SQL text of the query.
