Re: Alter Session

From: Mark J. Bobak <mark_at_bobak.net>
Date: Mon, 25 Jun 2001 07:22:56 GMT
Message-ID: <3B36E6D1.2287F5AF@bobak.net>

Sybrand Bakker wrote:
>
> "Sathish Balas" <sathishudercor_at_home.com> wrote in message news:<TEwY6.105285$qc.12947652_at_news1.rdc1.va.home.com>...
> > Do you need to have alter session privilege to change your own password in
> > any version of oracle ?
>
> No,
>
> You need alter user privilege.
> Be aware this allows you to alter *any* user, including sys.
>
> Hth,
>
> Sybrand Bakker, Oracle DBA

'alter any user' would allow you to alter any user.

A user only needs 'create session' to be able to change his password.

-Mark Received on Mon Jun 25 2001 - 02:22:56 CDT