RE: changing password

Jared,

Yes, you could use "Password" command.... from SQL Prompt

Rama

-----Original Message-----
From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of jared still Sent: Thursday, December 28, 2000 2:46 PM To: Multiple recipients of list ORACLE-L Subject: RE: changing password

On Thu, 28 Dec 2000, Norwood Bradly A wrote:

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

Norwood,

Do you know of some other way to change a users password in SQL*Plus other than via ALTER USER?

Jared Still
Certified Oracle DBA and Part Time Perl Evangelist ;) jkstill_at_teleport.com
jared_still_at_enron.net

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: jared still
  INET: jkstill_at_teleport.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).