Adsense Ad

Monday, 13 March 2017

How to enable/disable case sensitive passwords in Oracle11g?

Oracle 11g Oracle 10g (thanks to @Mac for commenting that!) introduces a new security feature: case sensitive passwords, but in Oracle 11g this feature is turned on by default.
Case sensitive passwords may cause problems if you run an old version of Oracle Forms (6i in my case) with an Oracle 11g database. The LOGON built-in sends the password to the database un UPPERCASE, so if the passwords doesn’t match, you cannot login to the database.
To disable case sensitive passwords in oracle 11g you have to modify the SEC_CASE_SENSITIVE_LOGON initialization parameter:

SQL> connect sys/oracle as sysdba

SQL> show parameter SEC_CASE_SENSITIVE_LOGON

SQL> sec_case_sensitive_logon       boolean   TRUE
 
SQL> alter system set sec_case_sensitive_logon=false scope=both;



To enable case sensitive passwords again, revert back to true.

No comments: