Case Sensitive OS Usernames Do not Map to Case Sensitive Oracle Usernames (Doc ID 735576.1)

Last updated on SEPTEMBER 01, 2011

Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.1 and later   [Release: 10.2 and later ]
Information in this document applies to any platform.
Checked for relevance on 30-Aug-2011

Symptoms

It is not possible to use case sensitive OS users to connect to Oracle case sensitive users. Consider the following scenario:

create user "Test" identified externally; 
create user test identified externally;
grant create session to "Test";
grant create session to test;

At OS level:
useradd Test

Of course, OS_AUTHENT_PREFIX is set to '', for the sake of simplicity in this scenario.
As well, the Oracle environment should be set appropriately for the "Test" users.
Now, if connected at OS level as Test:
su - Test
sqlplus /
SQL> show user
user is "TEST"

As seen, the "Test" OS user would map to the non-case sensitive user in the database.
Furthermore, if the non case sensitive database user test is dropped from the database:

drop user test;

Trying to connect again with the Test user:

su - Test
sqlplus /
ERROR:
ORA-01017: invalid username/password; logon denied

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms