title: Grant execute permission for a user on all stored procedures in database?
body: <p>I generated script from old database, created a new database and imported all data from old database. So far so good, however, no user has execute rights for stored procedures. I know I can use</p>
  <pre><code>GRANT EXECUTE ON [storedProcName] TO [userName] 
  </code></pre>
  <p>If it was just a few procedures, however, I have about 100 so what's the easiest way for me to grant execute access for a specific user to all of them?</p>