Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: changing password

Re: changing password

From: Dara Vaughn <dara.vaughn_at_wcom.com>
Date: Thu, 28 Dec 2000 15:59:47 -0600
Message-Id: <10724.125414@fatcity.com>


Nechama,

alter user username identified by values 'encryptedpassword';

Dara Vaughn
Oracle DBA
Quality Software Engineering

> 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-----
> Sent: Thursday, December 28, 2000 2:25 PM
> To: 'Terry Ball'; Glasrot, Nechama
> Cc: 'ORACLE-L_at_fatcity.com'; 'oracledba_at_quickdoc.co.uk'
>
>
> terry ... thanks so much ... yup that did it! ...
>
>
> thank you ...
> nechama glasrot
> 561-981-0635
> nglasrot_at_edata.com
>
>
> -----Original Message-----
> Sent: Thursday, December 28, 2000 2:16 PM
> To: Glasrot, Nechama
> Cc: 'ORACLE-L_at_fatcity.com'; 'oracledba_at_quickdoc.co.uk'
>
>
> 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: Glasrot, Nechama
> INET: nglasrot_at_edata.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
Received on Thu Dec 28 2000 - 15:59:47 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US