Big company, little error

From: Dan Ignat <idan_at_core.ro>
Date: 12 Oct 2004 12:01:52 -0700
Message-ID: <c7a16134.0410121101.cc43539@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

Password unchanged !!!!! -- Yes changed! 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 Received on Tue Oct 12 2004 - 14:01:52 CDT