Home » Developer & Programmer » Forms » expiring password in oracle forms
expiring password in oracle forms [message #270962] Fri, 28 September 2007 10:23 Go to next message
Messages: 15
Registered: June 2007
Junior Member

we are using oracle 10g forms, we are going to implement expiring database passwords for every 90 days, so when we log in to the form I have to come up with a customized Alert , when the password is expired (giving all the new password restrictions).

on what trigger do i need to make the changes ( i thought it would in on-error or on-message).


Re: expiring password in oracle forms [message #270992 is a reply to message #270962] Fri, 28 September 2007 12:01 Go to previous message
Messages: 21146
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I wouldn't use those triggers, but rather WHEN-NEW-FORM-INSTANCE one. Select DBA_USERS.EXPIRY_DATE and warn a user that his/her password is about to expire; offer him/her to change it. After it is expired, do not offer but demand.
Previous Topic: open color picker
Next Topic: Http Listner not found on 8889 port (Developer 10g)
Goto Forum:

Current Time: Thu Aug 17 03:02:30 CDT 2017

Total time taken to generate the page: 0.09835 seconds