Message-Id: <10724.125414@fatcity.com> From: Dara Vaughn Date: Thu, 28 Dec 2000 15:59:47 -0600 Subject: Re: changing password Nechama, alter user username identified by values 'encryptedpassword'; Dara Vaughn Oracle DBA Quality Software Engineering ----- Original Message ----- From: Glasrot, Nechama To: Multiple recipients of list ORACLE-L Sent: Thursday, December 28, 2000 1:30 PM Subject: 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@edata.com > > > -----Original Message----- > Sent: Thursday, December 28, 2000 2:25 PM > To: 'Terry Ball'; Glasrot, Nechama > Cc: 'ORACLE-L@fatcity.com'; 'oracledba@quickdoc.co.uk' > > > terry ... thanks so much ... yup that did it! ... > > > thank you ... > nechama glasrot > 561-981-0635 > nglasrot@edata.com > > > -----Original Message----- > Sent: Thursday, December 28, 2000 2:16 PM > To: Glasrot, Nechama > Cc: 'ORACLE-L@fatcity.com'; 'oracledba@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@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@LAZYDBA.com > > to subscribe send a blank email to oracledba-subscribe@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@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@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