Compare Page Revisions
« Older Revision - Back to Page History - Newer Revision »
CREATE LOGIN MyUserName WITH PASSWORD=N'MyPassword' GO CREATE USER MyUserName FOR LOGIN MyUserName GO ALTER USER MyUserName WITH DEFAULT_SCHEMA=[dbo] GO
CREATE USER MyUserName from LOGIN MyUserName go ALTER ROLE [db_datareader] ADD MEMBER MyUserName GO ALTER ROLE [db_datawriter] ADD MEMBER MyUserName GO --This next line is optional --GRANT EXECUTE ON schema::dbo TO MyUserName GO
ScrewTurn Wiki version 3.0.1.400. Some of the icons created by FamFamFam. Except where noted, all contents Copyright © 1999-2024, Patrick Jasinski.