Grant access to full v$session to a common user in multitenant
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