Test user authentication against the database

Now we will test our configuration by authenticating to the database using a user identity in the OID user realm.

Login to sqlplus using a user identity in the OID user realm.

Example:

# sqlplus nlewis/welcome1

Verify the user authentication with the following command.

SQL> select user from dual;

This command shows you the database schema user used to connect to the database.

The next command shows you the user context in OID that was used to connect to the database.

SQL> select sys_context ('userenv' , 'external_name') from dual;

This command should show the external user name that was used to connect to the database.

Watch a viewlet to see how its done.