Prior to 11g Passwords in Oracle are not case sensitive. Now from 11g Oracle passwords are Case sensitive. Parameter sec_case_sensitive_logon has been included in Oracle 11g.
SQL> show parameter logon
NAME TYPE VALUE
------------------------------------ --------------------------------- ------------------------------
sec_case_sensitive_logon boolean TRUE
SQL> conn amit/AMIT
ERROR:
ORA-01017: invalid username/password; logon denied
Warning: You are no longer connected to ORACLE.
SQL> conn amit/amit
Connected.
Disable Password case sensitive :-
SQL> alter system set sec_case_sensitive_logon=false;
SQL> show parameter logon
NAME TYPE VALUE
------------------------------------ --------------------------------- ------------------------------
sec_case_sensitive_logon boolean TRUE
SQL> conn amit/AMIT
ERROR:
ORA-01017: invalid username/password; logon denied
Warning: You are no longer connected to ORACLE.
SQL> conn amit/amit
Connected.
Disable Password case sensitive :-
SQL> alter system set sec_case_sensitive_logon=false;
System altered.
SQL> conn amit/AMIT
Connected.
Case Sensitive has been Disabled.
I hope this article helped you.
Regards,
Amit Rath
No comments:
Post a Comment