Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Alter Session
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