At the bottom of most stored procedures, we have a grant similar to
GRANT EXECUTE ON [dbo].[uspFOO] TO [DOMAIN\SQLServerUsers]
Fortunately for me, our domain is changing, and now we need to go through and change the permissions. Does anyone know an easy way to do this using the DB metadata so that I can pull out all the places where [DOMAIN \ SQLServerUsers] got permission to run and replace it with [DOMAIN2 \ SQLServerUsers]?
Thank.
For those who ask, this is on SQL Server 2005.
source
share