EXEC sp_addrolemember N'db_datareader',N'User1'; GRANT INSERT,UPDATE,SELECT ON MyTable TO User1 --for multiples,it's TO User1,User2
