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