Oracle Database 12c Security Cookbook

Creating a local role

Local roles are roles created in PDB and they exist only in that PDB. These roles can be granted only locally to either common or local users or roles.

Getting ready

For this recipe, a pluggable database (in our case, pdb1) should be open. You'll need an existing user (either common or local) who has create role privilege in that pluggable database.

How to do it...

1. Connect to PDB (for example, pdb1) as a common or local user who has        create role privilege in that PDB (for example, c##maja):

   SQL> connect c##maja@pdb1
   

2. Create a local role (for example, local_role1):

   c##maja@PDB1> create role local_role1 container=current;
   

How it works...

When you create a local role, that role exists only in the pluggable database in which ...