Query results differ when not sysdba

932976

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.

Unknown

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.
 

And in your other thread I ask you to SHOW us:

1. WHAT you are doing

2. HOW you are doing it

3. The actual results you get

4. The results you expect to get.

12c Multitenant Queries

Saying you don't get any results is totally meaningless. If you execute a query in Oracle you will get a result of some sort: an exception, a result set with data, an empty result set.

And saying you get 'appropriate results' is equally meaningless. We can't really help you if you don't SHOW us what you are doing.