login check to reset password after 90 days

[jwasden]

I have been assigned the task of developing a login.aspx page for a
website that pulls the user information from the tblUsers table in the
sql database. After the username is verified, it has to be reset after
first login and again after 90 days. This is something I have never
done before and I am having trouble deciding the best way to get it
working. Is the best way to create a column in the tblUsers table
called last login and set it to 100 days when the user is created? Any
help or code samples would be appreciated,

jwpaco

 

[Nick Hounsome]

I have been assigned the task of developing a login.aspx page for a
website that pulls the user information from the tblUsers table in the
sql database. After the username is verified, it has to be reset after
first login and again after 90 days. This is something I have never
done before and I am having trouble deciding the best way to get it
working. Is the best way to create a column in the tblUsers table
called last login and set it to 100 days when the user is created? Any
help or code samples would be appreciated,

Firstly try to get rid of the requirement - your users will hate you.

The only way I can remember all my web site passwords is by making them the
same.

Even my bank doesn't ask me to change my password so what are you trying to
protect?

 

[Ignacio Machin \( .NET/ C# MVP \)]

Hi,

Very easy, keep in the table the date they last changed the password, when
they login check it, and start prompting for changing the password a few
days before.

The code should be extremely simple, so IMO there is no need to provide it,
it's more fun writing it

btw, as Nick said this is not a very user friendly idea to start with.