List of Orphan user in DB

We can list out all the orphan users from a database using below query…

USE <database_name>

Exec sp_change_users_login @Action=’Report’; 
GO;

Fix Orphan user in DB

After finding orphan users, we can do user and login mapping using below query…

USE <database_name>
Exec sp_change_users_login @Action=’update_one’, @UserNamePattern='<database_user>’, @LoginName='<login_name>‘
GO