Go Up
You are here: DeploymentConfigure Netwrix Auditor Service AccountsData Collecting AccountGrant 'Create Session' and 'Select' Privileges to Access Oracle Database

Grant 'Create Session' and 'Select' Privileges to Access Oracle Database

When creating a monitoring plan for your Oracle Database, you should specify the account that has sufficient privileges to collect data from the database. At least, the following privileges are required:

  • CREATE SESSION – allows an account to connect to a database.
  • SELECT – allows an account to retrieve data from one or more tables, views, etc.

Alternatively, you can assign the default administrator role to that account.

You can grant the required privileges to an existing account, or create a new one. Follow the procedure described below.

Alternatively, you can grant the default administrator role to that account. For that, execute:

GRANT DBA TO <> <account_name>;

Go Up