• The following thing works for me for granting execute permissions on all the procedures to a role:

    grant EXEC to <rolename>

    The same way i was thinking and thats how my mind started dreaming.:-)