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.
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© 2025 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center