--ISSUE----
I am connected to the container database(root) in 12c
SQL> sho user
USER is "C##ABCXYZ"
SQL> create user c##coe123 identified by welcome container=all;
create user c##coe123 identified by welcome container=all
*
ERROR at line 1:
ORA-01031: insufficient privileges
The following is the DDL for that user created by SYS user
---C##ABCXYZ USER DDL -- THIS ONE WAS CREATED AS SYS ---
CREATE USER C##ABCXYZ
IDENTIFIED BY <password>
DEFAULT TABLESPACE USERS
TEMPORARY TABLESPACE TEMP
PROFILE DEFAULT
ACCOUNT UNLOCK;
-- 1 Roles for C##ABCXYZ
GRANT CDB_DBA TO C##ABCXYZ;
ALTER USER C##ABCXYZ DEFAULT ROLE ALL;
-- 3 System Privileges for C##ABCXYZ
GRANT CREATE SESSION TO C##ABCXYZ;
GRANT CREATE USER TO C##ABCXYZ;
GRANT SET CONTAINER TO C##ABCXYZ;