title: What privileges to grant in order to select from all PDBs
body: <p>Why both select doesnt return the same result?
  Or if you want more general question - What privileges to grant in order to select from all PDBs.</p>
  
  <pre><code>conn / as sysdba
  
  create user c##nir identified by c##nir container=all;
  
  grant connect,dba,resource to c##nir container=all;
  grant select on cdb_synonyms to c##nir container=all;
  
  select CON_ID  from cdb_synonyms  group by CON_ID;
  
      CON_ID
  ----------
           1
           4
          11
          10
          14
           5
           8
          13
           3
           7
          15
           6
          12
           9
  
  conn c##nir/c##nir
  
  select CON_ID  from cdb_synonyms  group by CON_ID;
  
      CON_ID
  ----------
           1
  
  select CON_ID  from containers(dba_synonyms)  group by CON_ID
                                 *
  ERROR at line 1:
  ORA-00942: table or view does not exist
  </code></pre>