stored procedure permission | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

stored procedure permission

one of the developer has a stored procedure that selects a data from one table and update to another table.
i moved that stored procedure from development server to production server. i gave that developer grant execute permission for that stored procedure.
since that stored procedure selects and do update the tables, do i need to give update permission to that developer to that underlying tables also.
thanks
Execute permission of the procedure should handle it…
MohammedU.
Moderator
SQL-Server-Performance.com
>>since that stored procedure selects and do update the tables, do i need to give update permission to that developer to that underlying tables also. Doing so would defeat the purpose of having a stored proc. You just need to give the user EXEC permission on the stored proc. ***********************
Dinakar Nethi
SQL Server MVP
***********************
Also, if the user has any permission explicitly denied on the underlying table, this will prevent the stored procedure from having success. Am I the only one uncomfortable with implicit permissions outside of server roles?
]]>