ORA-65049: Creation Of Local User Or Role Is Not Allowed In CDB$ROOT
Problem :While creating a user in root container in the multitenant database, Got this error.
Solution :Normal user i.e local user can’t be created in root container. Only common users starting with C## can only be created in root container Which is accessible from CDB as well as PDB Level.
SQL> create user C##TESTUSER identified by TESTUSER; User created.