Create user container parameters in Oracle 12c
In cdb, the Default User Creation is container = all. You cannot set container = current. In pdb, the Default User Creation is container = current. You cannot set container = all 1. use the container parameter in pdb to create a user: SQL> show con_name CON_NAME------------------------------TEST SQL> create user scott identified by tiger container = all; create user scott identified by tiger container = all * ERROR at line 1: ORA-65050: Common DDLs only allowed in CDB $ root SQL> create user scott identified by user container = current; User created. SQL> show con_name CON_NAME------------------------------TEST 2. create parameter SQL> show con_name CON_NAME------------------------------CDB $ root SQL> create user d identified by d; create user d identified by d * ERROR at line 1: ORA-65096: invalid common user or role name SQL> create user c # d identified by d container = current; create user c # d identified by d container = current * ERROR at line 1: ORA-65094: invalid local user or role name SQL> create user c # d identified by d container = all; User created. SQL> show con_name CON_NAME------------------------------CDB $ ROOT