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: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

Reply via email to