RE: Password is not case sensity and uncrypted

From: Donahue, Adam <adam.donahue_at_hcmny.com>
Date: Fri, 04 Oct 2002 10:18:29 -0800
Message-ID: <F001.004E10A1.20021004101829@fatcity.com>

There are certain rules Oracle uses for its names, one of which is that names are case insensitive. Password falls under these rules.

That said, you can override these rules by enclosing the password in quotation marks (just as you could do the same for a table).

So

SQL> alter user myuser identified by "CaseSenSitIve"

will store the password in a case-sensitive manner.

But then you must use quotation marks when connecting as well, e.g.,

$ sqlplus myuser/"CaseSenSitIve"

And I'm not sure this will work across platforms. A Metalink note (61424.999) on this topic indicates that UNIX seems to support case-sensitive passwords, while Windows does not.

About encryption, typically Oracle stores passwords in an encrypted format by default.

Adam

-----Original Message-----
Sent: Friday, October 04, 2002 1:48 PM
To: Multiple recipients of list ORACLE-L

Is password case-sensity in oracle database? And how do I encrypt it as it shows unencrypted in password field?

Thanks,
David
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Nguyen, David M
  INET: david.m.nguyen_at_xo.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Donahue, Adam
  INET: adam.donahue_at_hcmny.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Fri Oct 04 2002 - 13:18:29 CDT