Loading....

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.

Please follow and like us:

Last Update: June 22, 2009  

June 22, 2009 221 Arjun Raja
Total 0 Votes:
0

Tell us how can we improve this post?

+ = Verify Human or Spambot ?

Add A Knowledge Base Question !

You will receive an email when your question will be answered.

+ = Verify Human or Spambot ?

, ,

Leave a Comment

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

*
*

Social media & sharing icons powered by UltimatelySocial
Back To Top

Add A Knowledge Base Question !

You will receive an email when your question will be answered.

+ = Verify Human or Spambot ?