Link to home
Start Free TrialLog in
Avatar of rajputamitd
rajputamitd

asked on

Alert User to change password.

Hi,

I am using SQL2005 n .Net 3.5

I have a field in my table as Updatedate which contain last update date of the password.

Now I want to force user to change his password after 60 days.Before this,I want to remind him for the password change from 54th day.

6 days left.
55th day 5 days left
..........
.........
60 th day.0 days left and now you have to change the password.

How to do this?
Avatar of tigin44
tigin44
Flag of Türkiye image

create a stored procedure to control the password expiration and prepare your massages. In your application do always call this procedure while user login in as the first job. And take the required steps that neede to do...
Avatar of rajputamitd
rajputamitd

ASKER

Can you guide me or show an example how to write such store procedure.
 
Thank u.
ASKER CERTIFIED SOLUTION
Avatar of havj123
havj123
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Thanks 4 ur reply.I'll try it later n let you know.