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
Information in this document applies to any platform.
Checked for relevance on 30-Aug-2011
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:
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
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
ORA-01017: invalid username/password; logon denied
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