RE: changing password

From: Glasrot, Nechama <nglasrot_at_edata.com>
Date: Fri, 29 Dec 2000 07:29:52 -0500
Message-Id: <10725.125440@fatcity.com>

no problem ... thanks for the effort ... but fyi ... if u enclose the = pwd in
" " then it will accept it with a number e.g. "22abc" ... and then = when you
log on to sql+ u do it in the normal fashion connect user1/22abc @whatever

happy new year!

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

-----Original Message-----
From: Ron Rogers [mailto:RROGERS_at_galottery.org] Sent: Thursday, December 28, 2000 3:51 PM To: Multiple recipients of list ORACLE-L Subject: RE: changing password

nechama,
I did some checking after my first response. I could not find it in = any of
my books BUT the password can not begin with a number or special = characters.
Sorry to have sent you on a goose chase about the profiles. ROR m=AA=BF=AAm

>>> Bradley.A.Norwood_at_M1.IRSCOUNSEL.TREAS.GOV 12/28/00 03:05PM >>> 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-----
Sent: Thursday, December 28, 2000 1:10 PM To: Multiple recipients of list ORACLE-L

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=20

--=20

Please see the official ORACLE-L FAQ: http://www.orafaq.com=20
--=20

Author: Glasrot, Nechama
INET: nglasrot_at_edata.com=20

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).
--=20

Please see the official ORACLE-L FAQ: http://www.orafaq.com=20
--=20

Author: Norwood Bradly A
INET: Bradley.A.Norwood_at_M1.IRSCOUNSEL.TREAS.GOV=20

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

--=20

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--=20

Author: Ron Rogers
INET: RROGERS_at_galottery.org

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------