Cacher is the code snippet organizer for pro developers

USE [MyDB]
GO
CREATE ROLE [MyRole] 
GO
GRANT SELECT, UPDATE, INSERT, DELETE, EXECUTE on SCHEMA::[dbo] to [MyRole]
GO