| expiring password in oracle forms [message #270962] |
Fri, 28 September 2007 10:23  |
bharat0201
Messages: 15
Registered: June 2007
|
Junior Member |
|
|
Hi,
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).
thanks
|
|
|
|
| Re: expiring password in oracle forms [message #270992 is a reply to message #270962] |
Fri, 28 September 2007 12:01  |
 |
Littlefoot
Messages: 21818
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
