For security reasons, we developers don't have access to our live databases. However, read-only access is temporarily granted when we need to investigate specific problems that are happening in live. The problem is that we simply get added to the db_datareader role, which allows us to select from tables, but not to run any SPs or UDFs even if they only read data and don't perform any updates.

Short of getting permissions granted specifically for every SP or UDF we might need, is there a global way of granting such permissions?