Oracle Case sensitive password

Oracle Case sensitive password

Check value of SEC_CASE_SENSITIVE_LOGON parameter

SQL> show parameter sec_case_sensitive_logon; 
NAME TYPE VALUE
-------------------------------------------------- 
sec_case_sensitive_logon boolean TRUE

For testing purpose create a user and grant required privileges
SQL> create user test identified by TeSt; User created. SQL> grant create session to test; Grant succeeded.

Try to connect user with case sensitive password, it should work.
SQL> conn test/TeSt Connected.

Lets try to connect user with password in Lower Case
SQL> conn / as sysdba
Connected. 

SQL> conn test/test 
ERROR:
ORA-01017: invalid username/password; logon denied
Warning: You are no longer connected to ORACLE.
For re testing, configure Case Sensitivity off for user name and password 

SQL> conn / as sysdba
Connected. 

SQL> show parameter sec_case_sensitive_logon;
NAME TYPE VALUE
------------------------------------ -----------
sec_case_sensitive_logon boolean TRUE

SQL> alter system set sec_case_sensitive_logon=false scope=both;
System altered.

SQL> show parameter sec_case_sensitive_logon
NAME TYPE VALUE 
------------------------------------ -----------
 sec_case_sensitive_logon boolean FALSE
 
Try to login again with password in lower-case.
SQL> conn testuser/mypassword Connected.