> -----Original Message-----
> From: Sinardy Xing [mailto:[EMAIL PROTECTED]]
>
> I am using Oracle 8.1.6 Solaris 7
> Install patch bug1225555 for SQL*PLUS
>
> How can I change user password with special character
> alter user teddy identified by bear&12#$;
>
> is not working because of &
>
> alter user teddy identified by 'bear&12#$';
>
> also not working
>
> I have password_verification profile with verify_function
> that provided by
> Oracle Administrator Guide that must at least 1 special
> character in user
> password.
Two things:
a) the "&" is a special character for SQL*Plus, used for string substitution.
b) Passwords, like database object names, must be surrounded by double quotes when they contain "special" characters.
e.g.
SQL> -- turn off "&" substitution
SQL> set define off
SQL> -- surround password by " for special char.
SQL> alter user jrk identified by "bear&12#$" ;
User altered.
------
Jacques R. Kilchoer
(949) 754-8816
Quest Software, Inc.
8001 Irvine Center Drive
Irvine, California 92618
U.S.A.
http://www.quest.com
