Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Alter Session

Re: Alter Session

From: Mark J. Bobak <mark_at_bobak.net>
Date: Mon, 25 Jun 2001 07:36:45 GMT
Message-ID: <3B36EA0D.22436115@bobak.net>

"Mark J. Bobak" wrote:
>
> 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

Allow me to correct myself. I was half right on this one, as Sybrand was. 'alter any user' does not exist. 'alter user' allows one to alter any user. However, in refernce to the original question, 'alter user' is not required for a user to alter his own password. Only 'create session' is required for that.

Sorry for the confusion,

-Mark Received on Mon Jun 25 2001 - 02:36:45 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US