Re: changing password

syntax is

    alter user <username> identified by values '<encrypted value>';

Note that the encrypted values is enclosed in single quotes.

Terry

"Glasrot, Nechama" wrote:

> 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:51:42 CST