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

SQL> show con_name


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


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.



We can create normal user in PDBs