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 it is created. Local roles cannot be created in the root container. These roles are traditional roles.

Figure 15

c##maja@CDB1> select * from dba_roles where role='LOCAL_ROLE1';


    no rows selected



    c##maja...