Re: HELP - ORACLE SET PASSWORD

>
> Re: HELP - ORACLE SET PASSWORD
>
> kingaroo_at_aol.com (Kingaroo)
> 4 Oct 1995 06:51:30 -0400
> America Online, Inc. (1-800-827-6364)
>
> Newsgroups:
> comp.databases.oracle
> References:
> <Pine.SUN.3.91.951003085528.17359E-100000_at_seatimes>
>
> >> > ALTER USER <User's Login> IDENTIFIED BY <NewPassword>?
> >>
> >> it wont work if 'User' has no DBA privileges.
> >>
> >>
> >Strange. It works here all the time and the users definitely DO NOT
 have
> >DBA privileges.
> then check if the following works too at your site, then e-mail me ;)
> CONNECT SCOTT/TIGER;
> ALTER USER SYSTEM IDENTIFIED BY BOSS;
> CONNECT SYSTEM/BOSS;
  This matter has been explained here over and over! ;( Anyone can use the ALTER USER command to change his/her _OWN_ password. You don't need DBA privs.

   You only need DBA privs to alter _Someone_Else's_ password.

RTMF!

    _   _  _ _  __    : Paul Roberts                 
   |_  |_|  |  |      : Programmer / Analyst        
    _| | | _|_ |__    : proberts_at_isc901.jsc.nasa.gov 

Scientific Applications International Corporation

   (An employee-owned company)

  The opinions expressed are my own, and not necessarily   the views of SAIC, NASA, or the U.S. government. Received on Tue Oct 10 1995 - 00:00:00 CET