icon Join the 3-Day Free Live Sessions on Data Science with Gen AI ENROLL NOW

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
  • 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.

lets talk - learnomate helpdesk

Let's Talk

Find your desired career path with us!

lets talk - learnomate helpdesk

Let's Talk

Find your desired career path with us!