Database Administration (MOSC)

MOSC Banner

Grant access to full v$session to a common user in multitenant

edited May 7, 2021 3:48PM in Database Administration (MOSC) 3 commentsAnswered ✓

Hi

On oracle 19c I have 1 PDB/CDP and created a common user c##user on all container with grant select on v_$session

Here are some results:



Could you tell me how I can get all v$session with c#user in CDB, not only 62 lines, like sysdba does?

And I have the same question for v$process, but I suppose if I understand for v$session, the same will apply for v$process ...

I even tried a grant sysdba to c#user, but I still only have 62 session.

Thanks for help

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