RE: changing password

and now for the other baffler ...
user abc originally identified by something ... password unkown to dba but i have the encrypted value from dba_users' table ... i changed the id password temporarily ... now i need to change it back to its original value ... can this be done?

again ... TIA ....

thank you ...
nechama glasrot
561-981-0635
nglasrot_at_edata.com

-----Original Message-----
From: Glasrot, Nechama
Sent: Thursday, December 28, 2000 2:25 PM To: 'Terry Ball'; Glasrot, Nechama
Cc: 'ORACLE-L_at_fatcity.com'; 'oracledba_at_quickdoc.co.uk' Subject: 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
Received on Thu Dec 28 2000 - 13:27:49 CST