select data from mgmt$ views not working from other user
SQL> create user testusr identified by xxxxxx;
User created.
SQL> grant create session to testusr;
Grant succeeded.
SQL> grant select on sysman.mgmt$target to testusr;
Grant succeeded.
SQL> connect testusr
Enter password:
Connected.
SQL> select count(1) from sysman.mgmt$target;
COUNT(1)
----------
0
Elapsed: 00:00:00.09
SQL> connect / as sysdba
Connected.
SQL> select count(1) from sysman.mgmt$target;
COUNT(1)
----------
2046
Elapsed: 00:00:00.07
SQL>