Category: SQL Server
view more software Tips and Tricks
Updated: 11/24/2012 09:11 AM
Author: Shiju Mathews
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.