A while back I posted a script someone shared with me to generate grants on functions and stored procs to a user. I discovered it is pretty crappy and convoluted. I built this instead:

select     'grant execute on ' + [name] + ' to public'  
from     sysObjects
where     (
        xtype = 'P'
    or     xtype='FN'
    )
and    [name] not like 'dt_%'