Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Query results differ when not sysdba

932976Aug 7 2014 — edited Aug 7 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.

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Sep 4 2014
Added on Aug 7 2014
1 comment
844 views