sqlexpired-sessions

Set count down day for the password field in a table user of SQL

I have to set count down day for the password field in a table user to renew again by user.

If not renewed he should not be able to login.

This should be done in SQL user table, and should be done every time after a 30 day expiry period.

So please help me in this....

Solution

  • Store the password created date in user records table.

    Set up a job that runs every day to query from this the table and retrieve the records where currentdate-passwordcreateddate > 30.

    Set up job to send out notification to users in this result set.