Re: oracle password file?

From: Jomarlen <jomarlen_at_aol.com>
Date: 1997/10/08
Message-ID: <19971008163001.MAA20069@ladder01.news.aol.com>#1/1

You can change user passwords without knowing the existing password:

ALTER USER <username> IDENTIFIED BY <new_password>

Example

ALTER USER scott IDENTIFIED BY tiger;

John

---

John C. Lennon
Utility Partners Inc.
4300 West Tropicana Blvd LVO-UPL
Las Vegas NV 89103

FOR UTILITY PARTNERS EMPLOYMENT
OPPORTUNITIES VISIT www.utilpart.com

e-mail: jomarlen_at_aol.com
Web Site: http://members.aol.com/jomarlen/

The views expressed in this message
are those of the author and not
necessarily those of U.P. Inc.
and/or its employees.

---

>Subject: oracle password file?
>From: sweth_at_gwis2.circ.gwu.edu (Sweth Chandramouli)
>Date: Wed, Oct 8, 1997 09:44 EDT
>Message-id: <61g2o7$31d_at_gwis2.circ.gwu.edu>
>
>+ i just "inherited" an oracle database at work, to which no one
>seems to know any of the passwords. is there some easy way to (with root
>access on the machine) reset these manually, or will i need to reinstall
>oracle? someone suggested to me that the passwords were stored in the
>/opt/oracle7/dbs/orapwWG73 file, which could be edited with root access;
>if so, i can't figure out the format of that file. any suggestions would
>be appreciated.
>
> -- sweth.
>
>--
>.
>
>
>
>
>
>
>
Received on Wed Oct 08 1997 - 00:00:00 CDT