Creating a common user

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.

Getting ready

To complete this recipe, you'll need an existing common user who has create user privilege granted commonly.

How to do it...

1. 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
   
   

2. Create a common user (for example, c##maja):

          c##zoran@CDB1> create user c##maja identified by oracle1
          container=all;  
   
   

How it works...

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...