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.
-- Android Development Center
-- Cloud Development Project Center
-- HTML5 Development Center
-- Windows Mobile Development Center