Refer http://sqlism.blogspot.com/2014/09/script-to-sync-up-logins-and-database.html

syncup the logins and users

USE DATABASE

GO

EXEC sp_change_users_login 'update_one'

,'databse username'

,'loginname'

GO