Re: Alter Session

This is simply not true, at least not in 8.1.6.3 and in 8.1.7.1:

SQL>
SQL> connect system/????????@devdb
Connected.
SQL>
SQL> drop user testus cascade;

User dropped.

SQL>
SQL> create user testus identified by testus   2 default tablespace users
  3 temporary tablespace temp;

User created.

SQL>
SQL> grant create session to testus;

Grant succeeded.

SQL>
SQL> revoke alter session from testus;
revoke alter session from testus
*
ERROR at line 1:
ORA-01952: system privileges not granted to 'TESTUS'

SQL>
SQL> connect testus/testus_at_devdb
Connected.
SQL>
SQL> password
Changing password for TESTUS
SQL>
SQL> connect testus/abc_at_devdb
Connected.

Martin

"Daniel A. Morgan" 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 Sun Jun 24 2001 - 02:56:05 CDT