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...
Connect to PDB (for example,
pdb1
) as a common user or local user who hascreate user
privilege in that PDB (for example,c##zoran
or system user):SQL> connect c##zoran@pdb1
Create a local user (for example,
mike
):c##zoran@PDB1> create user mike identified by pa3t5brii container=current;
How it works...
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##
orC##
A local user cannot be created in the root
A local user exists in one and only one PDB and owns a schema...