Re: Alter Session

From: Mark J. Bobak <mark.NOSPAM_at_bobak.net>
Date: Fri, 22 Jun 2001 07:24:24 GMT
Message-ID: <20010622.032424.1186452551.19994@bobak.net>

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
>
Received on Fri Jun 22 2001 - 02:24:24 CDT