Please find the relevant steps in users and login mapping process:

1) When we restore a database, the users associated with the database gets restored.

2) using sp_help_revlogin, we generate the script...