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
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