-
SQL Permissions
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
-
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
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Development Centers
-- Android Development Center
-- Cloud Development Project Center
-- HTML5 Development Center
-- Windows Mobile Development Center
|