Share
If you have a large number of stored procedures in your SQL Server 2005 and you have to give EXEC permission to a database user on all of them then the best way to do it is by running the following SQL
SELECT ‘ GRANT EXEC ON ‘+ name +’ TO <database_user> ‘ [...]
