SQL Permissions

[ian]

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.

Cheers
Ian

[Rob Vieira]

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
TableA

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
www.ProfessionalSQL.com

"ian" <iang@intervate.com> wrote in message news:3a6e8a8c$1@news.devx.com...
>
> 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.
>
> Cheers
> Ian