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
ScrewTurn Wiki version 3.0.1.400. Some of the icons created by FamFamFam. Except where noted, all contents Copyright © 1999-2024, Patrick Jasinski.