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


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

Original text of this message