This procedure will assist in granting execute rights to a database user to all the stored procedures in a database
The parameters to this procedure are the databasename and the username to whom EXECUTE rights need to be given to
The assumption here is that the user already has access
rights to the database mentioned in the parameter list
Depending on the coding standards in your company you can
replace the string s_% with any other text for stored
When doing bulk data changes it may be beneficial to disable indexes prior to starting the operation. Fortunately, SQL's rich metadata makes this very easy to automate in a robust fashion.