Re: HELP - ORACLE SET PASSWORD
From: Steve Butler <sbut-is_at_seatimes.com>
Date: 1995/10/09
Message-ID: <Pine.SUN.3.91.951009123537.3440A-100000_at_seatimes>#1/1
Date: 1995/10/09
Message-ID: <Pine.SUN.3.91.951009123537.3440A-100000_at_seatimes>#1/1
On 3 Oct 1995, Scott Urman wrote:
> |> >> 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.
A non-DBA person can alter other users passwords IF they have been granted the ALTER USER system privilege.
+----------------------------------------------------+ | Steve Butler Voice: 206-464-2998 | | The Seattle Times Fax: 206-382-8898 | | PO Box 70 Internet: sbut-is_at_seatimes.com | | Seattle, WA 98111 Packet: KG7JE_at_N6EQZ.WA | +----------------------------------------------------+All standard and non-standard disclaimers apply. All other sources are annonymous. Received on Mon Oct 09 1995 - 00:00:00 CET