Permissions to use SPs and UDFs that don't update data

[digitalShaman]

running this in your database:
GRANT EXECUTE ON SCHEMA :: dbo TO <YourDatabaseUser/Group>

should allow you to run all the SP. However some of these might alter data so this will open a backdoor.