Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: changing password
terry ... thanks so much ... yup that did it! ...
thank you ...
nechama glasrot
561-981-0635
nglasrot_at_edata.com
-----Original Message-----
From: Terry Ball [mailto:terry_ball_at_csgsystems.com]
Sent: Thursday, December 28, 2000 2:16 PM
To: Glasrot, Nechama
Cc: 'ORACLE-L_at_fatcity.com'; 'oracledba_at_quickdoc.co.uk'
Subject: Re: changing password
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:24:54 CST