Message-Id: <10724.125399@fatcity.com> From: Terry Ball Date: Thu, 28 Dec 2000 13:15:55 -0600 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@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