Search This Blog

Sunday, March 23, 2008

Oracle 11g Password CaSe SEnsiTivE

New Capability
Now Oracle 11g Database password is Case Sensitive.


C:\Users\ian>sqlplus CHEST/norma@m

SQL*Plus: Release 11.1.0.6.0 - Production on Mon Mar 10 22:56:47 2008

Copyright (c) 1982, 2007, Oracle. All rights reserved.


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

SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Pr
oduction
With the Partitioning, OLAP, Data Mining and Real Application Testing options

C:\Users\ian>sqlplus CHEST/NORMA@m

SQL*Plus: Release 11.1.0.6.0 - Production on Mon Mar 10 22:56:59 2008

Copyright (c) 1982, 2007, Oracle. All rights reserved.

ERROR:
ORA-01017: invalid username/password; logon denied

http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:708040800346734217

And in oracle 10g

C:\>sqlplus scott/tiger

SQL*Plus: Release 10.1.0.5.0 - Production on Sun Mar 23 10:12:46 2008

Copyright (c) 1982, 2005, Oracle. All rights reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.1.0.5.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL> conn scott/TIGER
Connected.



How can disable password case sensitive option in oracle 11g


In 11g there is one password for enable / disable password case sensitive option.

sec_case_sensitive_logon


http://download.oracle.com/docs/cd/B28359_01/server.111/b28320/initparams211.htm#REFRN10299

No comments: