News
Perth, Australia
+ (61) 417713124
prosolutions@gavinsoorma.com

11g Passwords can be case sensitive

  • Posted by Arjun Raja
  • On June 22, 2009
  • 0 Comments
  • 11G, case sensitive password, password case sensitive

In 11g – Passwords are case sensitive but this can be controlled by an init.ora parameter –

SQL> show parameter SEC_CASE_SENSITIVE_LOGON ;

NAME TYPE VALUE
———————————— ———– ——————————
sec_case_sensitive_logon boolean TRUE

SQL> create user arjun identified by ARJUN; – Password in Upper Case.

User created.

SQL> grant create session to arjun;

Grant succeeded.

SQL> conn arjun/arjun; – Tried to connect with lower case password – FAILS.
ERROR:
ORA-01017: invalid username/password; logon denied

Warning: You are no longer connected to ORACLE.
SQL> exit
apex:/u01/oracle> sqlplus “sys as sysdba”

Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 – 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> conn arjun/ARJUN – CONNECTS –
Connected.
SQL>exit

Sqlplus “sys as sysdba”

? drop user arjun cascade;

Now alter the parameter to FALSE – so case sensitive passwords are not required.

SQL> alter system set sec_case_sensitive_logon=false;

System altered.

SQL> create user arjun identified by ARJUN;

User created.

SQL> grant create session to arjun;

Grant succeeded.

SQL> conn arjun/arjun; – Connects with lower case password although password at time of creation was in UPPER case.

 

0 Comments

Leave Reply

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