PROBLEM:

While creating a user in root container multitenant database, got the below error.

SQL> show con_name

CON_NAME
—————————-
CDB$ROOT

SQL> create user TESTUSER identified by TESTUSER;
create user TESTUSER identified by TESTUSER
*
ERROR at line 1:
ORA-65096: invalid common user or role name

SOLUTION:

We can’t create normal users in root containers. We can create only common users which start with c## in root container.

A user that is present in both root container and PDB is known as a common user.i.e a common user can log into any container, but the privileges of a common user can be administered separately within each PDB. For example, a common user might have the privilege to create a table in one PDB but not in another.

SQL> show con_name

CON_NAME
------------------------------
CDB$ROOT
SQL> create user c##TESTUSER identified by TESTUSER;

User created.

We can create normal user in PDBs