RE: changing password

From: Glasrot, Nechama <nglasrot_at_edata.com>
Date: Thu, 28 Dec 2000 14:46:55 -0500
Message-Id: <10724.125404@fatcity.com>

an added fyi ... if you surround the encrypted password with single ticks 'encrypted password' you get the following error ...

SQL> alter user abc identified by 'A8561025DBD09074'; alter user abc identified by 'A8561025DBD09074'

ERROR at line 1:
ORA-00988: missing or invalid password(s)

however if you surround the encrypted password with a "encrypted" it completes successfully ...

User altered.

i really have no way to verify that it is correct as the customer does not know the correct password ... i guess i'll assume it's ok till i get beeped otherwise ... thank you and i apologize for my recurrence of blonditis ( with apologies to the blondes out there) ...

thank you ...
nechama glasrot
561-981-0635
nglasrot_at_edata.com

-----Original Message-----
From: Glasrot, Nechama
Sent: Thursday, December 28, 2000 2:40 PM To: 'William Beilstein'; Glasrot, Nechama; ORACLE-L_at_fatcity.com Subject: RE: changing password

thank you all once again ... like duh ... i definitely think it's time to go home ... happy new year to all ...

thank you ...
nechama glasrot
561-981-0635
nglasrot_at_edata.com

-----Original Message-----
From: William Beilstein [mailto:BeilstWH_at_OBG.com] Sent: Thursday, December 28, 2000 2:35 PM To: nglasrot_at_edata.com; ORACLE-L_at_fatcity.com Subject: Re: changing password

alter user abc identified by values '22xyz_p';

>>> "Glasrot, Nechama" <nglasrot_at_edata.com> 12/28/00 02:10PM >>>
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

-- 
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 - 13:46:55 CST