Privileges for Oracle database-related queries

The credential user needs certain privileges to run queries on database-related data sources.
For Oracle Database Version 10g and later, you can provide the following privileges:
Privileges required for Oracle Database Version 10g and later
Privilege
Description
SELECT ANY DICTIONARY
Allows access to the required data dictionary objects.
SELECT ON SYSTEM.PRODUCT_USER_PROFILE
Allows access to the SYSTEM.PRODUCT_USER_PROFILE synonym, which is used for reporting in the SQL*Plus Security data source.
SELECT ON SYSMAN.MGMT$TARGET_COMPONENTS
Allows access to the SYSMAN.MGMT$TARGET_COMPONENTS object, which displays information about the software components that are associated with a managed target and details about where the software components have been installed.
In Oracle version 12c, the SELECT ANY DICTIONARY privilege does not include the Select privilege on the user$ table. If the SYSTEM user is specified for oracle credentials, Oracle Database Admin must grant the Select privilege on the user$ table to the SYSTEM user.
The following privileges grant access to the dictionary objects that are required for reporting on Database Audit Trail datasource:
  • SELECT ON SYS.OBJAUTH$
  • SELECT ON SYS.OBJ$
  • SELECT ON SYS.USER$
  • SELECT ON SYS.COL$
  • SELECT ON SYS.TABLE_PRIVILEGE_MAP