July 12, 2011 at 7:41 am
Just a quick question, if I wanted to give a 3rd party vendor only access enough to connect to my database and run a stored procedure, do I just give them EXECUTE & CONNECT rights?
Thanks in advance.
July 12, 2011 at 9:28 am
That really depends on what the sp does.
One way round it would be to grant access as you described (though they would need public) and alter the sp to run with execute as a different user. In this way the 3rd pty wouldnt need any other db access.
HTH
Adam Zacks-------------------------------------------Be Nice, Or Leave
July 12, 2011 at 10:06 am
That is a great idea. How can that be done? Do you have to somehow put the alter statement inside of the stored procedure to alter itself?
July 12, 2011 at 10:09 am
cloud9respect (7/12/2011)
That is a great idea. How can that be done? Do you have to somehow put the alter statement inside of the stored procedure to alter itself?
Google is your friend:
http://msdn.microsoft.com/en-us/library/ms188354.aspx
Adam Zacks-------------------------------------------Be Nice, Or Leave
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply