Regarding "Big company, little error"

Comments embedded.

"Dan Ignat" <idan_at_core.ro> wrote in message news:c7a16134.0410121101.cc43539_at_posting.google.com...
> Connected to:
> Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
> With the Partitioning, OLAP and Oracle Data Mining options
> JServer Release 9.2.0.1.0 - Production
> SQL> create user unnx identified by unnx password expire;
>
> User created.
>
> SQL> connect unnx/unnx
> ERROR:
> ORA-28001: the password has expired
>
>
> Changing password for unnx
> New password: ******(unnx22)
> Retype new password: ******(unnx22)
> ERROR:
> ORA-01045: user UNNX lacks CREATE SESSION privilege; logon denied
>

This error does not apply to the password change, it applies to the original logon attempt for unnx. Changing the password has nothing to do with actually connecting to the instance.

>
> Password unchanged !!!!! -- Yes changed!

This should not be a surprise since changing the password doesn't require the account to be logged onto the server as you have just found out.

> Warning: You are no longer connected to ORACLE.
> SQL> connect system
> Enter password: ******
> Connected.
> SQL> grant create session to unnx;
>
> Grant succeeded.
>
> SQL> connect unnx/unnx (because changed)
> ERROR:
> ORA-01017: invalid username/password; logon denied
>
>
> Warning: You are no longer connected to ORACLE.
> SQL> connect unnx/unnx22 (nice)
> Connected.
> SQL>
>
> Dan

I fail to see the 'problem' with this.

David Fitzjarrell Received on Tue Oct 12 2004 - 15:12:19 CDT