Hi Thye Hock Gan,
Thank you for your info.
I am using Oracle 8.1.6 Solaris 7
Install patch bug122 for SQL*PLUS
How can I change user password with special character
alter user teddy identified by bear12#$;
is not working because of
alter user teddy identified by
If you're using the a profile with a password_verify function, then you
shouldn't be using ALTER USER to change a user's password. If you are
trying to change the password through SQL*Plus, then you should instead be
using the SQL*Plus PASSWORD command:
SQL PASSWORD username
Using this command
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/*^%$$#
Title: RE: Password with special character
-Original Message-
From: Sinardy Xing [mailto:[EMAIL PROTECTED]]
I am using Oracle 8.1.6 Solaris 7
Install patch bug122 for SQL*PLUS
How can I change user password with special character
alter user teddy identified by bear12