We have a similar role in our development, testing, and production environments. It never occured to me to set something up to automatically grant execute permissions.

I agree with Brian that the db_executor role would make a nice addition to the SQL Server roles.

Nice article Brian.

Robert W. Marda

SQL Programmer

bigdough.com

The world’s leading capital markets contact database and software platform.