February 8, 2012 at 8:34 am
Is there a way I can add a user and then give this user rights to only execute stored procedures...no table access?
February 8, 2012 at 8:41 am
Checkout this post..
http://www.sqlservercentral.com/Forums/Topic1248558-1550-1.aspx#bm1248596
February 8, 2012 at 8:50 am
If the stored procedure and the table it references have the same owner then you dont need explicit permissions for the table. This is called ownership chaining. You can get more info here http://msdn.microsoft.com/en-us/library/ms188676.aspx
February 8, 2012 at 9:02 am
Granting EXECUTE permission on a stored procedure
The following example grants EXECUTE permission on stored procedure HumanResources.uspUpdateEmployeeHireInfo to an application role called Recruiting11.
USE AdventureWorks2008R2;
GRANT EXECUTE ON OBJECT::HumanResources.uspUpdateEmployeeHireInfo
TO Recruiting11;
GO
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply