| V11 password [message #262148] |
Fri, 24 August 2007 13:06  |
 |
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
|
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  |
 |
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
|
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 |
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
