Found this great article that has a really simple script to create the grant commands needed for all the procs in a database
Found this great article that has a really simple script to create the grant commands needed for all the procs in a database