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.
