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.
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.
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;
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...