My Oracle Support Banner

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

Last updated on AUGUST 04, 2018

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

To view full details, sign in with your My Oracle Support account.

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


In this Document
  Symptoms
  Cause
  Solution
  References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.