Bulk Granting EXECTUTE Permission on SQL Server
Here's some code I regularly find useful when going from a dev server to a production server (or changing the username), I'm sure there's a more automated way but for a quick fix...
DECLARE @username varchar(100)SET @username = 'xyz'SELECT'