Giving additional user privileges for tables in Oracle EBS v12.1.3

Giving additional user privileges for tables in Oracle EBS v12.1.3

For monitoring Oracle EBS v12.1.3, the following user privileges will be required to query data from the database:
  1. CONNECT role.
  2. SELECT_CATALOG_ROLE role.
  3. SELECT ANY TABLE role
The following commands can be executed in order to grant the above mentioned roles to the user.
  1. GRANT CONNECT TO user;
    GRANT SELECT_CATALOG_ROLE TO user;
    GRANT SELECT ANY TABLE TO user;
Note - The "user" mentioned in the above commands refers to the username of the user configured in Applications Manager for monitoring.

If the issue still exists, reach out to our support with the screenshot of the error obtained to appmanager-support@manageengine.com along with the latest Support Information File (SIF) from Applications Manager with print all logs enabled for analysis.