Local Users in a CDB

A local user is a user that is not common and that can operate only within a single pluggable database (PDB). Local users have the following characteristics:

• A local user is specific to a particular PDB and owns a schema in this PDB.

• A local user cannot be created in the root.

• A local user on one PDB cannot log in to another PDB or to the root.

• The name of a local user cannot begin with the characters c## or C##.

• The name of a local user must only be unique within its PDB.

• The user name and the PDB in which that user schema is contained determine a unique local user. For example, a local user and schema named rep can exist on a PDB named hrpdb. A completely independent local user and schema named rep can exist on a PDB named salespdb.

• Whether local users can access objects in a common schema depends on their user privileges.

  For example, the c##dba common user may create a table in the c##dba schema on the hrpdb PDB. Unless c##dba grants the necessary privileges to the local hr user on this table, hr cannot access it.