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?
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?
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...
ASKER
Can you guide me or show an example how to write such store procedure.
Thank u.
Thank u.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks 4 ur reply.I'll try it later n let you know.