ORA-65049: Creation Of Local User Or Role Is Not Allowed In CDB$ROOT

Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
  • User AvatarKiran Dalvi
  • 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.