Grant permissions to functions

select 'GRANT SELECT ON [' + SCHEMA_NAME(schema_id) + '].[' + name + '] TO [public]', *

from sys.objects

WHERE type_desc in ('CLR_TABLE_VALUED_FUNCTION', 'SQL_TABLE_VALUED_FUNCTION')

order by name

select 'GRANT EXECUTE ON [' + SCHEMA_NAME(schema_id) + '].[' + name + '] TO [public]', *

from sys.objects

WHERE type_desc in ('AGGREGATE_FUNCTION', 'CLR_SCALAR_FUNCTION', 'SQL_SCALAR_FUNCTION')

order by name