Case Sensitive OS Usernames Do not Map to Case Sensitive Oracle Usernames
Last updated on SEPTEMBER 01, 2011
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
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