11g: new feature Password Case sensitivity

Hi Everyone!!

Apps team is working on certifiying 11g DB with 11i and R12. Its time to know 11g features.!!

In this post I will be covering the new feature of 11g, Password case sensitvity!!

In R12 or 11i with 10g DB you might have seen

SQL> conn apps/apps

Connected.

SQL> conn apps/APPS

Connected.

apps password in CAPS as well as small let you to login without any errors. But with 11g DB you will get errors.

SQL> conn apps/apps
Connected.

SQL> conn apps/APPS
ERROR:ORA-01017: invalid username/password; logon denied

Warning: You are no longer connected to ORACLE.

If you want to have this feature disabled you can do so by running the below command as sysdba user

alter system set sec_case_sensitive_logon = false;

or you can set at init.ora parameter level too.

sec_case_sensitive_logon = FALSE

Hope you have got good info on this. Stay tuned for the next update.