RE: changing password

From: Norwood Bradly A <Bradley.A.Norwood_at_M1.IRSCOUNSEL.TREAS.GOV>
Date: Thu, 28 Dec 2000 15:00:53 -0500
Message-Id: <10724.125406@fatcity.com>

Perhaps, OEM or sqlplus..........

 Note: Oracle recommends that you do not change passwords using the ALTER USER statement because it does not fully support the password verification function. Instead, you should use Oracle-provided tools such as SQL*Plus or Enterprise Manager to change passwords

-----Original Message-----
From: Glasrot, Nechama [mailto:nglasrot_at_edata.com] Sent: Thursday, December 28, 2000 1:10 PM To: Multiple recipients of list ORACLE-L Subject: changing password

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 also send the HELP command for other information (like subscribing). Received on Thu Dec 28 2000 - 14:00:53 CST