Home » RDBMS Server » Security » V11 password
V11 password [message #262148] Fri, 24 August 2007 13:06 Go to next message
BlackSwan
Messages: 22520
Registered: January 2009
Senior Member
Am I having a brain cramp?
On versions prior to V11, AFAIK schema passwords are/were case insensitive.
Right?
Now on V11 I'm seeing the following:
10:53:51 SQL> CONNECT DBADMIN/ADMINDB
Connected.
10:54:04 SQL> CONNECT dbadmin/ADMINDB
Connected.
10:55:16 SQL> SELECT * FROM V$VERSION;

BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production
PL/SQL Release 11.1.0.6.0 - Production
CORE    11.1.0.6.0      Production
TNS for Linux: Version 11.1.0.6.0 - Production
NLSRTL Version 11.1.0.6.0 - Production

10:55:58 SQL> CONNECT dbadmin/admindb
ERROR:
ORA-01017: invalid username/password; logon denied


Warning: You are no longer connected to ORACLE.
11:00:07 SQL> 

Did the default behavior for case sensitity of passwords change between V10 & V11?
If so, where is the documented? I've looked for more than 1 hour.
If so, can the new behavior be overridden or reverted to prior behavior & how?

TIA & HAND!
Re: V11 password [message #262149 is a reply to message #262148] Fri, 24 August 2007 13:10 Go to previous messageGo to next message
Michel Cadot
Messages: 58607
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes it changes in 11g.
Before Oracle used DES encryption after converting to upper case now it directly uses SHA-1 algorithm.

Regards
Michel

[Hmm, it's a "security" question not a "SQL newbies", isn't it?]


[Updated on: Fri, 24 August 2007 13:14]

Report message to a moderator

Re: V11 password [message #262765 is a reply to message #262148] Tue, 28 August 2007 04:29 Go to previous messageGo to next message
muzahid
Messages: 281
Registered: September 2004
Location: Dhaka, Bangladesh
Senior Member
http://download.oracle.com/docs/cd/B28359_01/server.111/b28300/afterup.htm
Re: V11 password [message #262866 is a reply to message #262765] Tue, 28 August 2007 07:04 Go to previous messageGo to next message
Michel Cadot
Messages: 58607
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
More precisely:
http://download.oracle.com/docs/cd/B28359_01/server.111/b28300/afterup.htm#BABCHGFH
(This will prevent the other readers from making the same search that I did.)

Regards
Michel
Re: V11 password [message #267068 is a reply to message #262148] Wed, 12 September 2007 07:14 Go to previous message
Michel Cadot
Messages: 58607
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Have a look at Metalink note 429465.1

Regards
Michel
Previous Topic: priveledges
Next Topic: Default Account Management
Goto Forum:
  


Current Time: Tue Jul 29 05:18:52 CDT 2014

Total time taken to generate the page: 0.17357 seconds