Is there any way of determining what SQL permissions are required to execute
a stored proc. I don't care if I use another stored proc an extended stored
proc or an API call I just want to know if it is possible.
Re: SQL Permissions
I'm not sure I understand the question? The only permission generally
required to execute a stored proc is the EXEC right on that sproc. The
access to tables and other objects referenced by the sproc is implied by the
fact that you granted permission to run the sproc.
For example, Bob may not have any rights at all to TableA
Bob can have EXEC rights to spInsertTableA - which inserts a record into
In this mix, Bob couldn't insert a record into TableA using a direct INSERT
statement, but he could call spInsertTableA to insert the record (INSERT
authority is implied as along as it is within the scope of the sproc).
Rob Vieira MCSD, MCT, MCDBA
"ian" <firstname.lastname@example.org> wrote in message news:email@example.com...
> Is there any way of determining what SQL permissions are required to
> a stored proc. I don't care if I use another stored proc an extended
> proc or an API call I just want to know if it is possible.
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL