Re-Associating a Server Login to a Database User - SQL Server

Overview

When copying a database from one instance of SQL Server, database-level User objects are copied with the database. However, server-level Logins are not. This article gives a sample script to re-associate an existing server Login to a database User.

Script

USE [MyDatabase]
GO
ALTER USER [MyUser] with LOGIN = [MyLogin]
GO
ALTER USER [MyUser] WITH DEFAULT_SCHEMA=[dbo]
GO
EXEC sp_addrolemember N'db_datareader', N'MyUser'
GO
EXEC sp_addrolemember N'db_datawriter', N'MyUser'
GO
grant execute on schema::dbo to MyUser