EM 13c: New Enterprise Manger 13c Cloud Control Administrator Returns Incorrect Data from Sysman Views

(Doc ID 2298475.1)

Last updated on SEPTEMBER 05, 2017

Applies to:

Enterprise Manager Base Platform - Version 12.1.0.1.0 and later
Information in this document applies to any platform.

Symptoms

Enterprise Manager (EM) 13.2 Cloud Control
User administration

A new EM 13.2 administrator, USER1, is created for monitoring credentials with the following attributes:

CREATE SESSION
SELECTANY DICTIONARY
SELECT ANY TABLE

However, USER1 does not obtain the expected results from the SYSMAN view queries on the repository database:

Example
SQL> show user
USER is "SYS"
SQL> select count(*) from sysman.mgmt_targets;

COUNT(*)
----------
59

SQL> show user
USER is "USER1"
SQL> select count(*) from sysman.mgmt_targets;

COUNT(*)
----------
0



Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms