How to make Oracle Case sensitive password

Prior to 11g there was no method to make password case sensitive but in 11g they have introduced to do this by parameter SEC_CASE_SENSITIVE_LOGON

Lets create a user and grant required privileges:

SQL> create user test identified by Test1;
User created.

SQL> grant create session to test;
Grant succeeded.

SQL> conn test/Test1


But when we try to login with case sensitive password then show error as below:

SQL> conn test/test1
ORA-01017: invalid username/password; logon denied
Warning: You are no longer connected to ORACLE.


Now lets set sec_case_sensitive_logon parameter false as below:

SQL> conn / as sysdba
SQL> sho parameter sec_case_sensitive_logon;

NAME                                        TYPE           VALUE
-------------------------------------    -----------    ------------------------------
sec_case_sensitive_logon                    boolean        TRUE

SQL> alter system set sec_case_sensitive_logon=false scope=both;
System altered.

SQL> show parameter sec_case_sensitive_logon
NAME                                        TYPE       VALUE
------------------------------------     -----------    ------------------------------
sec_case_sensitive_logon                    boolean      FALSE



Now try to loging with password in lower case:

SQL> conn test/test1

It will get connected..

Please share If you like..Share on FacebookShare on Google+Tweet about this on TwitterShare on LinkedInShare on Yummly


Add a Comment
  1. I refer the related information on Oracle DBA from your site.
    Thanks for providing your information on Oracle DBA Online Training

Leave a Reply

Your email address will not be published. Required fields are marked *

Fariddin Shaikh's Oracle DBA Blog © 2016 Being DBA
Go Back