prompt(pop up) to change the password before it gets expired

Database

prompt(pop up) to change the password before it gets expired

what parameter need to be set while creating a user through a query such that he will get a prompt(pop up) to change the password before it gets expired.

I am not sure if something like this exists but I was asked this question.I know that when a new user is created it will prompt to change the temporary password, do we have this same thing applicable in this case?