
Oracle Database 12c Security Cookbook
By :

A common user is a user created in the root container, which has the same identity across all containers. The main purpose of a common user is to perform "infrastructure" administrative tasks, such as starting up a CDB, plugging and unplugging PDBs, and opening PDBs. There are two types of common users: Oracle-supplied (for example, SYS
and SYSTEM
) and user-created common users.
To complete this recipe, you'll need an existing common user who has create user
privilege granted commonly.
Connect to the root container as a common user who has create user
privilege granted commonly (for example, c##zoran
or system user):
SQL> connect c##zoran@cdb1
Create a common user (for example, c##maja
):
c##zoran@CDB1> create user c##maja identified by oracle1
container=all;
c##maja
is actually not a single user, but each container has a user named c##maja
and the passwords must be the same.
Figure...