Orphaned sql users

 If you restore database,there are scenarios when our user gets orphaned.

USE myDb
EXEC sp_change_users_login 'Report'






If you do have orphaned users, you can restore them if they exist but they are not linked to actual logins.

EXEC sp_change_users_login 'Auto_Fix', 'user'