I created a common user and granted it select on CDB% views. When I run the follwing query while connected to CDB$ROOT I don't get any results:
SELECT pdb, network_name FROM CDB_SERVICES WHERE pdb is not null AND con_id>2;
But when I connect as sysdba I get the appropriate results. Why is this?
I want to create a common user that can create PDBs without sysdba privileges and I want that user to be able to query the status of all PDBs.