Database Administration (MOSC)

MOSC Banner

select data from mgmt$ views not working from other user

edited May 16, 2020 2:08PM in Database Administration (MOSC) 9 commentsAnswered

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>

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center