Before you start monitoring your Oracle Database with Netwrix Auditor, arrange your environment. Depending on your current database version and edition, Oracle provides different types of auditing:
- Standard Auditing—For Oracle Database 11g. In Standard Auditing, you use initialization parameters and the
NOAUDITSQL statements to audit SQL statements, privileges, schema objects, network and multitier activities. See Configure Oracle Database 11g for Auditing for more information.
- Unified Auditing—Recommended for Oracle Database 12c. Unified Auditing consolidates all auditing into a single repository and view. This provides a two-fold simplification: audit data can now be found in a single location and all audit data is in a single format. See Configure Oracle Database 12c for Auditing for more information.
- Fine Grained Auditing—Available for Oracle Database Enterprise Edition only. Allows auditing of actions associated with columns in application tables along with conditions necessary for an audit record to be generated. It helps focus on security-relevant columns and rows and ignore areas that are less important. See Configure Fine Grained Auditing for more information.
If you are unsure of your audit settings, refer to the following section:
Also, remember to do the following:
- Configure Data Collecting Account, as described in Grant Create Session and Select Privileges to Account
- Configure required protocols and ports, as described in Protocols and Ports Required for Monitoring Oracle Database