Oracle create pdb manager user
How the Oracle Multitenant Option Affects Privileges


  A common user connected to the root can see metadata pertaining to
  PDBs by way of the container data objects (for example, multitenant
  container database (CDB) views and V$ views) in the root, provided
  that the common user has been granted privileges required to access
  these views and his CONTAINER_DATA attribute has been set to allow
  seeing data about various PDBs.


SQL&gt; create user C##ADMIN identified by adminpass container=all ;

User created.

SQL&gt; GRANT CREATE SESSION, SYSOPER,PDB_DBA,DBA, CREATE PLUGGABLE DATABASE TO c##admin CONTAINER=ALL ;

Grant succeeded.

SQL&gt; conn C##ADMIN/adminpass
Connected.
SQL&gt; select PDB_NAME from cdb_pdbs;

no rows selected


Granting the required privilege:

SQL&gt; conn / as sysdba
Connected.
SQL&gt; alter user c##admin set container_data=all for cdb_pdbs container=current;

User altered.

SQL&gt; conn C##ADMIN/adminpass
Connected.
SQL&gt; select PDB_NAME from cdb_pdbs;

PDB_NAME
---------
PDB$SEED
PDB1