Creating a local user

A local user is a user that is created and that exists in only one PDB. A local user can't be created in the root container.

Getting ready

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

How to do it...

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

          SQL> connect c##zoran@pdb1
   

2. Create a local user (for example, mike):

          c##zoran@PDB1> create user mike identified by pa3t5brii
          container=current;
   

How it works...

Figure 9

Rules/guidelines for creating and managing local users

There are a few rules you should be aware of:

• The name of a local user must be unique within its pluggable database and it must not begin with c## or C##

• A local user cannot be created in the root

• A local user exists in one and only one PDB and owns a schema...