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