An Oracle databases policy using Oracle stored procedures is setup to make the Oracle password for each user to expire in 90 days, the grace period will be 10 days. The policy is working fine except when in the grace period, SQL Navigator does not show any message at all.
ex. In a Unix prompt, when the password is about to expire,
user$ sqlplus database
SQL*Plus: Release 10.1.0.4.0 - Production on Mon Oct 2 13:09:55 2006 Copyright (c) 1982, 2005, Oracle. All rights reserved.
Enter password:
ERROR:
ORA-28002: the password will expire within 1 days
However when logging onto SQL Navigator as the same user, "ORA-28002: the password will expire within 1 days" is not shown.
Currently, when the password expires, at first logon after expiration, a pop up window "Your password has expired" appears with entries for a new password and verification. If the new password is accepted, then logon continue. If the pop up is cancelled then "ORA-28001: the password has expired" appears. Password Grace Time is set in the profile and it can be done in SQL Nav, however, warning msg (ORA-28002) with elapsing time to expiry is not implemented in the GUI.
STATUS:
An enhancement request has been submitted to Development for consideration in future release for SQL Navigator for Oracle
