About Me

My photo
Bangalore, India
I am an Oracle Certified Professional working in SAP Labs. Everything written on my blog has been tested on my local environment, Please test before implementing or running in production. You can contact me at amit.rath0708@gmail.com.

Monday, September 30, 2013

Disable Case Sensitive in Oracle Database 11g

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
ORA-01017: invalid username/password; logon denied

Warning: You are no longer connected to ORACLE.
SQL> conn amit/amit

Disable Password case sensitive :-

SQL> alter system set sec_case_sensitive_logon=false;

System altered.

SQL> conn amit/AMIT

Case Sensitive has been Disabled.

I hope this article helped you.

Amit Rath

No comments:

Post a Comment