Oracle Database 12c Security Cookbook

Creating and using proxy users

In this recipe, you'll learn about proxy users.

Getting ready

To complete this recipe, you'll need an existing (for example, OS-authenticated) user who has a DBA role and another existing user (for example, mike).

How to do it...

1. Connect to the database as a user who has a DBA role:

   $ sqlplus /
   
   

2. Create a proxy user named appserver:

   SQL> create user appserver identified by oracle_1;
   
   

3. Grant create session to the user appserver:

   SQL> grant create session to appserver;
   
   

4. Alter the user to connect through the proxy user:

   SQL> alter user mike grant connect through appserver;
   

5. Connect to the database through proxy user:

   SQL> connect appserver[mike]
   

6. Enter a password for the appserver user (for example, oracle_1):

   Enter password: ...