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:
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