I Created 1 Table and and stored procedure.(Sql server 2008)
I need to give access right to users
I created Group called Group1 and i add some users for that.
For example Table1 and Stored Procedure1
I gave this Grant using code below(T-sql)
GRANT EXECUTE ON Table1 TO [TestServer1\Group1];
GRANT EXECUTE ON stored procedure1 TO [TestServer1\Group1];
its execute successfully.
My query is I need to write VB.net code using following connection String
connetionString= "Data Source=TestServer1;Initial Catalog=MainDB;Integrated Security=SSPI"
Could you any one show me How to give permission Table1 and Storedprocedure1
Need grant to access Insert,Delete,Execute store procedures1 and Table1