1、原12cR2多租户架构数据库中已经创建了公共用户C##TEST:
SQL> select * from cdb_sys_privs where grantee like 'C##%';
GRANTEE PRIVILEGE ADM COM INH CON_ID
-------------------- ---------------------------------------- --- --- --- ----------
C##TEST CREATE SESSION NO YES YES 3
C##TEST CREATE SESSION NO YES NO 1
C##TEST CREATE SESSION NO YES YES 5
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 ORCLPDB1 READ WRITE NO
5 ORCLPDB2 READ WRITE NO
2、将PDB orclpdb2拔出并将用户C##TEST删除:
SQL> alter pluggable database orclpdb2 close immediate;
Pluggable database altered.
SQL> alter pluggable database orclpdb2 unplug into '/tmp/orclpdb2.xml';
Pluggable database altered.
SQL> drop pluggable database orclpdb2;
Pluggable database dropped.
SQL> drop user C##TEST;
User dropped.
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 ORCLPDB1 READ WRITE NO
SQL>
3、然后将PDB orclpdb2插回来,此时被插回来的PDB中也没有了common user C##TEST:
SQL> create pluggable database orclpdb2 using '/tmp/orclpdb2.xml' nocopy;
Pluggable database created.
SQL> alter pluggable database orclpdb2 open;
Pluggable database altered.
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 ORCLPDB1 READ WRITE NO
4 ORCLPDB2 READ WRITE NO
SQL> select * from cdb_sys_privs where grantee like 'C##%';
no rows selected
SQL> select username,common,con_id from cdb_users where username like 'C##%';
no rows selected
SQL> select username,common,con_id from cdb_users where username= 'C##TEST';
no rows selected
可以看到,被拔出的数据库重新插入后,原common user C##TEST也被删除。