Help with Login Information

I have generated user Registrattion, LogIn, profile, Logout and EmailPW pages using SA. I intent to design an Admin page. Also, I have added a column to the users table called "firstLogin" with values Yes or NO in the same column. ( I am not sure if the two values YES or NO should be in same or different columns of the "firstLogin" column of the user table)
My goal is that when user login for the first time the user is taken to the newPassword page to change their password and if it is not the first time the user login, the user taken to the Profile.php page.
Below is what I have done.

1) Created two session variables FirstloginYes and FirstloginNO
2) Updated server behavior of the userLogin page(3rd step) by adding the firstLogin column with column value(FirstloginYes). I don't know when to use the FirstloginNO
3) Created a rule "firsttimelogin" using rule manager.

Using Access Rule manager, Should I select "Allow" or "Restrict"?
What should be the 1) value:
2) criteria:
3) compare to:

Can anyone help with clear step by step on how to accomplish this. I will appreciate your help.

use 1 and 0 as the values for the firstLogin column.

set the default value to 0.

you only need to one session named firstLogin, this session will be set to either 0 or 1 based on the value stored in the firstLogin column.

if the session firstLogin is = to 0, it is the first time they are loging in, if = to 1, they have changed the password.

create the firsttimelogin rule as:
allow if
For the value, click the lightning bolt and select the firstLogin session

set the critiria to "="

set the comparison to "0"

Jason,
As always, thanks a lot for your feedback. I will try it.

you're welcome.

Hello Support
I have followed the instructions and got stuck. This is what I have done. Using the Login page, I send user after they login to profile page if it not their first time. Then on the profile page, I have applied the "firsttimelogin" rule using the Access rule manager.
For the failed redirect on the profile page, I would like to send the user on the new password page.
How can I accomplish this?


Any help will be appreciated.
Thanksin advance

use the Not firsttimelogin rule instead.

Hello Support,
Thanks for the feedback. The redirection seems to work. But even if one has previously login, one is still being redirected to the New Password page. My goal is that for any first time login, the user is redirected to the New Password page. And the next time the same user is logs in, the user is directed to the userProfile page. I have followed exactly what you instructed me to do, but each time I login, it still takes me to New Password page eventhough it is the second or third time that I logged in.
Any help will be appreciated.
Thanks for your time.

on the new password page, you will need to update the firstLogin column to 1 instead of 0 at the same time the password is updated.

Hello Support,
Thanks again for your support. I just did what you instructed me to, but nothing is being updated. That is, I used the DA update server behavior to do that and when I tested the login page it still took me to newpassword page. Also I checked on my database and nothing was updated to the firstlogin column.
Any suggestion or help will be appreciated.
Thanks alot for your continuous help

please post a copy of your page so i can examine the code.