Block SSRS Developers from embedding SQL Statements in Report
create a database schema (lets say "reporting"), and add only the stored procedures you want the developer to have access to that schema, grant the allowed users access only to that schema.