SQL> create user c##common identified by common container = all;

User created.

SQL> grant create session to c##common container = all;

Grant succeeded.

SQL> grant select on dba_pdbs to c##common container = all;

Grant succeeded.

SQL> grant select on cdb_pdbs to c##common container = all;

Grant succeeded.

SQL> connect c##common@sol122/common
Connected.
SQL> select pdb_name from dba_pdbs;

no rows selected

SQL> select pdb_name from cdb_pdbs;

no rows selected

SQL> connect /@sol122 as sysdba
Connected.
SQL> alter user c##common set container_data=all container=current;

User altered.

SQL> connect c##common@sol122/common
Connected.
SQL> select pdb_name from dba_pdbs;

PDB_NAME
--------------------------------------------------------------------------------
PDB1SOL122
PDB$SEED

SQL> select pdb_name from cdb_pdbs;

PDB_NAME
--------------------------------------------------------------------------------
PDB1SOL122
PDB$SEED

SQL>