If you are using security assist, the security assist wizard will create the user profile page automatically.
In security assist, when the user logs in, their ID is stored in a session variable.
The profile page contains a recordset that filters the user table on the users ID session variable to show their details. and allow them to update their user record.
you can examine the profile page that security assist creates to get a better understanding of how it works.