在PDB中赋予公共用户create session权限，默认该公共用户仅能连接该PDB，无法连接其他PDB

创建公共用户：
SQL> create user C##TEST identified by test container=all;
User created.
SQL> select username,common from dba_users where oracle_maintained='N';
USERNAME     COM
------------------
C##TEST      YES

测试公共用户默认无法连接PDB：
SQL> show pdbs
    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 ORCLPDB1                       MOUNTED
         4 ORCLPDB2                       READ WRITE NO
SQL> alter session set container=orclpdb2;
Session altered.
SQL> select username,common from dba_users where oracle_maintained='N';
USERNAME     COM
------------ ---
PDBADMIN     NO
C##TEST      YES
TEST         NO
SQL> conn C##TEST/test