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.
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.
Connect to PDB (for example,
pdb1
) as a common or local user who hascreate role
privilege in that PDB (for example,c##maja
):SQL> connect c##maja@pdb1
Create a local role (for example,
local_role1
):c##maja@PDB1> create role local_role1 container=current;