Question: can db_datawriter execute stored procedures?
Answer: If you simply excute SELECT statements, the db_datareader role should fit for executing your stored procedures. The db_datawriter is the role, that is eligible to create them. Jan P. Permissions for creating and executing procedures are documented under CREATE PROCEDURE and EXECUTE , respectively.