title: How to grant execute permissions to the stored procedures in a specific schema?
body: <p>Is there a way in SQL Server 2012 to grant execute all stored procedures in one schema?
  For additional info, these stored procedures are doing just a select.</p>