Is there a way to grant a group of specific store proc. to a user?

Is there a way to grant a group of specific store proc. to a user?

Post by ZG90bmV0bm » Fri, 15 Jun 2007 02:57:00


I'm using MS SQL studio express edition and it is a pain in the ass to grant
store proc. to a user by clicking. is there a better to do so?

thank
 
 
 

Is there a way to grant a group of specific store proc. to a user?

Post by Jon Skeet » Fri, 15 Jun 2007 03:07:58


Could I suggest you ask in a SQL Server newsgroup?

--
Jon Skeet - < XXXX@XXXXX.COM >
http://www.yqcomputer.com/ ~skeet Blog: http://www.yqcomputer.com/
If replying to the group, please do not mail me too

 
 
 

Is there a way to grant a group of specific store proc. to a user?

Post by Nicholas P » Fri, 15 Jun 2007 03:25:42


Well, you could access SQL Server programatically by using the SQL
Server Management Objects (SMO).

--
- Nicholas Paldino [.NET/C# MVP]
- XXXX@XXXXX.COM