Oracle Database 12c Security Cookbook

Creating password-authenticated users

In this task, you will create several users.

Getting ready

To complete this recipe, you'll need an existing user who has create user privilege (you may use the OS-authenticated user who has the DBA role).

You'll use Oracle Enterprise Manager Database Express 12c (EM Express). To learn more about it (for example, how to configure an HTTPS port for EM Express and how to start it), see the third chapter of the official Oracle guide -Oracle Database 2 Day DBA, 12c Release 1.

How to do it...

1. Connect to the database as a user who has create user privilege:

          $ sqlplus /
   
   

2. Create a password-authenticated user (for example, username: jessica, password: oracle_1) as follows:

          SQL> create user jessica identified by oracle_1; ...