Re: HELP - ORACLE SET PASSWORD

From: Scott Urman <surman_at_oracle.com>
Date: 1995/10/03
Message-ID: <44rvgg$97h_at_inet-nntp-gw-1.us.oracle.com>#1/1


In article <1995Oct3.141903.17441_at_schbbs.mot.com>, rossk_at_mack.geg.mot.com (Ross Klippert x2965) writes:
|>
|>
|> ---
|> In article a12_at_newsbf02.news.aol.com, kingaroo_at_aol.com (Kingaroo) writes:
|> >> How about
 

|> >> ALTER USER <User's Login> IDENTIFIED BY <NewPassword>?
|> >
|> >it wont work if 'User' has no DBA privileges.
|>
|> That's funny, I have configured a number of accounts without DBA
|> privilege and it works just fine for our development staff!

Without DBA privilege, you can only alter your own password. With DBA privilege, you can alter other people's passwords.

|>
|>
|> ------------------------------------------------------------------------------
|> Ross Klippert |
|> Motorola GSTG |
|> Scottsdale, AZ |
|> rossk_at_cso.geg.mot.com |
|> (602)-441-6794 |
|> ------------------------------------------------------------------------------
|>
|>
|>
Received on Tue Oct 03 1995 - 00:00:00 CET

Original text of this message