Grant Permissions to Account

IT Asset Management (Cloud)

The account used to access Oracle (suggested name FNMS-OEMadapter) must have adequate permissions to tables in the OEM repository. If you are setting up multiple instances of the OEM adapter, repeat the process for each adapter (you may be using a common account name for all of them to access each distinct OEM repository, or providing each with a unique account name). This task is normally completed by an Oracle DBA.

To provide appropriate permissions and validate operation:

1. To grant adequate read permission, do either of the following:
   1. Make the account (suggested name FNMS-OEMadapter) a member of the EM_ALLVIEWER role.
   2. Give the account read permissions on the following:
      • DBA_TABLES
      • MGMT_TARGETS
      • MGMT_TARGETS_LOAD_TIMES
      • MGMT_TARGET_TYPES
      • MGMT_TARGET_PROPERTIES
2. When permissions have been set up, test as follows:
   1. Log in using the account name (suggestion: FNMS-OEMadapter) and password registered during the installation process.
   2. Execute the following query against the OEM repository:

      SELECT * from mgmt$Target

      Note the number of rows returned.
   3. Log out, and log in using a DBroot account (or other account known to have full permissions); and repeat the same query.
      The same number of rows should be returned by the root account with full permissions, and by the account for the OEM adapter with more limited and specific permissions.
3. Repeat the process and testing for any further instances of the OEM adapter accessing other distinct instances of OEM repository.