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.



          New to M365 Manager Plus?
          New to M365 Manager Plus?
            New to RecoveryManager Plus?
            New to RecoveryManager Plus?
              New to Exchange Reporter Plus?
              New to Exchange Reporter Plus?
                New to SharePoint Manager Plus?
                New to SharePoint Manager Plus?
                  See all integrations
                  New to ADManager Plus?
                  See all integrations
                  New to ADManager Plus?

                    New to ADSelfService Plus?

                    Start your free trial
                    Start your free trial

                      • Related Articles

                      • How to import certificates for monitoring Oracle database with SSL authentication?

                        For users using Applications Manager version 14250 and below: One-way SSL: (Client authentication disabled) 1. Open the command prompt using 'Run as administrator' option and navigate to the Applications Manager installation directory. 2. Import your ...

                      • WMI Metrics Reference Tables

                        Windows Server Monitor - WMI Metrics Reference Tables This document lists the WMI namespaces, classes, and WQL queries used by AppManager Windows Server Monitor scripts in WMI mode. These reference tables can be used for troubleshooting WMI-related ...

                      • I am not able to add Oracle monitor, it says "Permission denied".

                        Reason: Applications Manager requires access to specific Oracle system views in order to collect database performance and availability metrics. If the configured Oracle user lacks sufficient privileges, the monitor cannot be added successfully and a ...

                      • The Oracle monitor is not working or is not collecting any data. What can I do?

                        Reason: If the Oracle monitor in ManageEngine Applications Manager is not collecting any data, the issue is most commonly caused by insufficient database privileges to execute the query by the Oracle user configured in the monitor. Solution: Go to ...

                      • Monitoring Oracle standby databases in Applications Manager

                        Do we support Oracle Standby Database monitoring? Yes, we do. How to connect to the Standby/Standalone Oracle database which is in MOUNTED mode? To connect to an Oracle database in STANDBY MOUNTED or normal MOUNTED mode, you must use the sysdba user ...
                      Related Products