Re: Password with special character

From: Bill Pribyl <bill_at_datacraft.com>
Date: Fri, 11 May 2001 12:34:56 -0700
Message-ID: <F001.003010E4.20010511090151@fatcity.com>

Sinardy Xing wrote:

> Hi all,
>
> Can Oracle User change their password with special characters?

As with other Oracle identifiers, you have to put double quotes around the password to include nonstandard stuff.

SQL> ALTER USER SCOTT IDENTIFIED BY "*&^%$$# L"; User altered.

SQL> CONNECT scott/"*&^%$$# L"
Connected.

Supposedly, lower case letters aren't supported in these passwords, but I've seen it work just fine.

Incidentally, double quotes are not supported by the SQL*Plus "password" command, which is a shame. I've logged a TAR on this problem.

Good luck
Bill

http://www.datacraft.com/ http://plnet.org/

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Bill Pribyl
  INET: bill_at_datacraft.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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 May 11 2001 - 14:34:56 CDT