ORA-65049: Creation Of Local User Or Role Is Not Allowed In CDB$ROOT
ANKUSH THAVALI
20 Dec, 2023
0 Comments
1 Min Read
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.