Steve,

Feel free to write about it. Too much work for me to get time to do any real writing. Just here to help where I can.

Jonathan,

Doesn't giving SELECT...

Steve,

Are you sure about the "no blanket" way?

I have used the role based execute permissions in SQL 2005 myself on previous database implementations.

There is more documentation on the process at:...

Jonathan,

In SQL 2005 you can now use roles to handle giving execute access to all stored procedures. In 2000 you had to query the information_schema to find all of...