How to fix sql server user permission problem after restore database.

To find orphand user list.

--------------------------

USE <database_name>;

GO;

sp_change_users_login @Action='Report';

GO;

To Auto fix sql ser problem.

---------------------------

USE DB_NAME

GO

EXEC sp_change_users_login 'auto_fix', 'USER_NAME'

GO