RE: changing password

thanks to eveyone who helped with password problems ... here is a summary of what i used

1/ password beginning with number
to change/create a password that begins with a number, enclose that password with " "
e.g.
SQL> create user abc_test identified by "123_pwd";

User created.

you can connect as abc_test/123_pwd ... the " are not req'd

2/ restore encrypted password
SQL> alter user <username> identified by values '<encrypted value>';

happy new year!

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:51 PM To: Multiple recipients of list ORACLE-L Subject: 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
> > Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Terry Ball
  INET: terry_ball_at_csgsystems.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may