Re: changing password

From: Terry Ball <terry_ball_at_csgsystems.com>
Date: Thu, 28 Dec 2000 13:15:55 -0600
Message-Id: <10724.125399@fatcity.com>

When a password starts with something other than a character, you need to enclose it in double quotes to change it.

Terry

"Glasrot, Nechama" wrote:

> i have a user named abc ... he had a password of 22xyz ... i had to
> temporarily change the password to abc_temp ... i tried to change the
> password back to 22xyz ... and get the following error ...
>
> Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production
> With the Partitioning option
> JServer Release 8.1.6.0.0 - Production
>
> SQL> alter user abc identified by 22xyz_p;
> alter user abc identified by 22xyz_p
> *
> ERROR at line 1:
> ORA-00988: missing or invalid password(s)
>
> pls help ... tia
>
> thank you ...
> nechama glasrot
> 561-981-0635
> nglasrot_at_edata.com
>
> --------
> Think you know someone who can answer the above question? Forward it to them!
> to unsubscribe, send a blank email to oracledba-unsubscribe_at_LAZYDBA.com
> to subscribe send a blank email to oracledba-subscribe_at_LAZYDBA.com
> Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Received on Thu Dec 28 2000 - 13:15:55 CST