Forum Stats

  • 3,875,295 Users
  • 2,266,907 Discussions
  • 7,912,141 Comments

Discussions

Query results differ when not sysdba

932976
932976 Member Posts: 8
edited Aug 7, 2014 11:02PM in Multitenant

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.

Answers

  • Unknown
    edited Aug 7, 2014 11:02PM
    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.

This discussion has been closed.