Hi,

I'm using an application(ie. Oracle form). On execution, Oracle Forms Runtime is activated..database logon presented. Apparently, if the user's password expired, Forms Runtime displays ,by default, a 'Change Password' dialog box.

I would like to not display this box. I'm exploring use of a custom on-logon trigger. Is it possible to check if a user's password has expired or is locked using this trigger. If password is locked, I would like to display 'password locked' message and close logon box. Similarly, on expiration, a 'password expired' message should be displayed....Could this be done ?? Any help please...I'd appreciate it..