Home / Software / Tips and Tricks / The EXECUTE permission was denied on the object , database , schema

The EXECUTE permission was denied on the object , database , schema

Updated:  11/24/2012 09:11 AM
Author:  Shiju Mathews

Status:    Resolved.


A login requires access permission, read and write permission on database. On top of that login requires "Execute permission" on stored procedure to excecute the SP's. You can go to each object and grand permission by runnig the following script.





OR if you want to give Execute permission to all stored procedure run the following query.