We have a consultant working with us. He needs to be able to see all of the code for our Stored Procs and functions.
We would like to avoid granting Execute permissions.
Is there a way to grant a permission where he could be able to view all the code w/o having the power to Execute the proc?
There are hundreds of procs/functions he will need access to.