Anomaly with password expire in OEM 10

From: EdStevens <quetico_man_at_yahoo.com>
Date: 27 Feb 2007 08:21:11 -0800
Message-ID: <1172593271.307943.155600@h3g2000cwc.googlegroups.com>

Oracle 10.2.0.2 on HP-UX

When setting up a new user or resetting a user's password, using OEM (DB Control) I select 'expire password now'. Checking the genned ddl, I see (as expected)

ALTER USER "STEVENSE" IDENTIFIED BY "****" PASSWORD EXPIRE; Apply it and the next time STEVENSE connects, he is *not* prompted for a new password. However, if I connect with sqlplus as SYSTEM and execute the same statement, the next time STEVENSE tries to connect, he *is* prompted for a new password.

Odd?? Received on Tue Feb 27 2007 - 10:21:11 CST