Re: HELP - ORACLE SET PASSWORD
From: Ron Ross <rross_at_lang1.langara.bc.ca>
Date: 1995/10/05
Message-ID: <451876$f2q_at_vcc7.vcc.bc.ca>#1/1
Date: 1995/10/05
Message-ID: <451876$f2q_at_vcc7.vcc.bc.ca>#1/1
Kingaroo (kingaroo_at_aol.com) wrote:
[SNIP]
: ok, check if this works at your site:
: CONNECT SCOTT/TIGER;
: ALTER USER SYSTEM IDENTIFIED BY SHMOE;
: CONNECT SYSTEM/SHMOE;
: if yes, then gimme guest account on your system ;)
The original poster asked for a solution to allow a user to change his/her own password. ALTER USER works fine for that without any DBA privelages. Try reading the posts before answering them.
-- ___ Oo .:/ (___)o_o ,,///;, ,;/ //====--//(_) o:::::::;;/// Ron Ross \\ ^ >::::::::;;\\\ <rross_at_langara.bc.ca> ''\\\\\'" ';\ I'd rather be diving !!!Received on Thu Oct 05 1995 - 00:00:00 CET