SOLVED

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

Asked by OracleDba••13 views•oracle
1
2
3
4
5
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.
#oracle#error

Solutions(1)

Accepted Solution
1
2
3
4
5
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.
OracleDba•

Post Your Solution