ORA-65049: Creation Of Local User Or Role Is Not Allowed In CDB$ROOT
While creating a user in root container in the multitenant database, Got error ORA-65049.
SQL> show con_name
SQL> create user TESTUSER identified by TESTUSER container=current;
create user TESTUSER identified by TESTUSER container=current
ERROR at line 1:
ORA-65049: creation of local user or role is not allowed in CDB$ROOT
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. And use either container=ALL or dont mention anything for container.
SQL> create user C##TESTUSER identified by TESTUSER;