-
Book Overview & Buying
-
Table Of Contents
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...