Oracle-L: Re: how to change password

From: Scott Stefick <sstefick_at_harpercollege.edu>
Date: Fri, 02 May 2003 09:42:09 -0800
Message-ID: <F001.0058E37A.20030502094209@fatcity.com>

Not sure if I quite understand your question, but I'll assume what I think you're asking and answer that question.

When you log into the database using sqlplus, you can do: SQL> ALTER USER yourUserName

2 IDENTIFIED BY yourNewPassword;

That will change your password in the database. If you're saying that you need a password to user sqlplus, that would be more of a Systems Administrator question.

-Scott

At 08:02 AM 5/2/03 -0800, you wrote:
>after i type sqlplus and provide my password and login into oracle.
>is there a way i can change my current password to use sqlplus?
>
>Thanks
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.net
>--
>Author: Jianping Zhu
> INET: jzhu_at_fisher.forestry.uga.edu
>
>Fat City Network Services -- 858-538-5051 http://www.fatcity.com
>San Diego, California -- Mailing list and web hosting services
>---------------------------------------------------------------------
>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).

Scott Stefick
Systems / Oracle Certified DBA
Wm. Rainey Harper College
sstefick_at_harpercollege.edu
847.925.6130

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Scott Stefick
  INET: sstefick_at_harpercollege.edu

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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 Fri May 02 2003 - 12:42:09 CDT