| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Password with special character
> -----Original Message-----
> From: Sinardy Xing [mailto:sinardyxing_at_bcsis.com]
>
> 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.
 |
 |