Re: Alter Session

"Mark J. Bobak" wrote:

> Um, I beg to differ. On my test database (8.1.7 on Linux),
> create user test identified by test;
> User created.
> grant create session to test;
> Grant succeeded.
> connect test/test
> alter user test identified by test1;
> User altered.
>
> The 'password' command also works.
>
> Also, if you DID need a system privilege, I'd think it would be 'alter
> user', not 'alter session'. But, it's not required.
>
> -Mark
>
> In article <3B32DCE2.8BB66DD8_at_exesolutions.com>, "Daniel A. Morgan"
> <dmorgan_at_exesolutions.com> wrote:
>
> > Sathish Balas wrote:
> >
> >> Do you need to have alter session privilege to change your own password
> >> in any version of oracle ?
> >
> > In EVERY version.
> >
> > Daniel A. Morgan
> >

You are absolutely correct. I misread the query.

Thanks.

Daniel A. Morgan Received on Fri Jun 22 2001 - 11:09:38 CDT