Before you start creating a monitoring plan to audit your Oracle Database, plan for the account that will be used for data collection – it should meet the requirements listed below. Then you will provide this account in the monitoring plan wizard.
CREATE SESSIONsystem privilege must be granted to the account used to connect to Oracle Database for data collection.
- Depending on your Oracle Database version, the
SELECTprivilege on the following objects must be granted to that account:
Oracle Database 11g
Oracle Database 12c
In addition to the privileges above, add the
SELECTprivilege on the following objects:
For Oracle Database 12c Release 2, also grant the
SELECTprivilege on the following object:
NOTE: To learn how to grant system privileges to the account, see Grant 'Create Session' and 'Select' Privileges to Access Oracle Database. Alternatively, you can grant the default administrator role to the account.
If you are going to configure Fine Grained Auditing, grant privileges depending on your Oracle Database version, and make sure that you are using Oracle Database Enterprise Edition.