Skip to Main Content

Database Software

12c Multitenant Queries

932976Aug 7 2014 — edited Aug 11 2014

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.

Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 8 2014
Added on Aug 7 2014