Oracle Database 12c Security Cookbook

Effects of plugging/unplugging operations on users, roles, and privileges

The purpose of this recipe is to show what is going to happen to users, roles, and privileges when you unplug a pluggable database from one container database (cdb1) and plug it into some other container database (cdb2).

Getting ready

To complete this recipe, you will need the following:

• Two container databases (cdb1 and cdb2)
• One pluggable database (pdb1) in the container database cdb1
• Local user mike in the pluggable database pdb1 with the local create session privilege
• The common user c##john with the create session common privilege and create synonym local privilege on the pluggable database pdb1

How to do it...

1. Connect to the root container of cdb1 as user sys:

   SQL> connect ...