Pete Finnigan's Oracle Security Forum


    
      
        Pete Finnigan's Oracle Security Forum
        (http://www.petefinnigan.com/forum/yabb/YaBB.cgi)
      

        Oracle Security >> Oracle Security >> Oracle Forms Runtime and on-logon trigger
        
(Message started by: Pete Finnigan on Feb 27^th, 2008, 2:33pm)

Title: Oracle Forms Runtime and on-logon trigger
Post by Pete Finnigan on Feb 27^th, 2008, 2:33pm

Hi,

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

I will like to not display this box. I'm exploring the 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, if password expired, I would like to display 'password expired' and close logon box.

I'd be grateful for any assistance.