Oracle 12c create user container parameters
The default for creating users under cdb is container=all, and container=current cannot be set.
The default for creating users under pdb is container=current, and container=all cannot be set.
1. Create a user with the container parameter under pdb:
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
two。 Create parameters under cdb user
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 cantilever 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 cantilever identified by d container=all
User created.
SQL > show con_name
CON_NAME
-
CDB$ROOT