When configuring Fine Grained Auditing, you need to create an audit policy with required parameters set. The procedure below contains instructions on how to create, disable and delete such audit policies.
NOTE: Fine Grained audit policies can be configured for Oracle Database Enterprise Edition only. Keep in mind that if you have Fine Grained policies configured, you will receive a permanent error in the Netwrix Auditor System Health log because Netwrix Auditor cannot detect it. Use Unified and Standard audit policies to keep track of data changes.
Fine Grained Auditing does not supported in Mixed mode.
To configure Fine Grained Auditing
Below is an example of Fine Grained audit policy that enables auditing of audit statements
(INSERT, UPDATE, DELETE, and
SELECT) on table
hr.emp to audit any query that accesses the
salary column of the employee records that belong to
sales department. Review the following for additional information:
|To...||Execute the following command...|
|To create audit policy||
|To disable audit policy||
|To delete audit policy||
NOTE: Refer to Oracle documentation for additional information on Fine Grained Auditing.