Tuesday, March 1, 2016

11g new feature Password Case sensitivity

11g new feature Password Case sensitivity

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


No comments:

Post a Comment