Find the GRANT in the Procedure Haystack

We need to weed out some failing stored procedures due to security changes.

Alot of errors coming from GRANT EXEC inside stored procedures that didnt need to be there.

Run the following query to speed along the discovery process:

SELECT ROUTINE_NAME, ROUTINE_DEFINITION
FROM INFORMATION_SCHEMA.ROUTINES
WHERE ROUTINE_DEFINITION LIKE ‘%GRANT %’
AND ROUTINE_TYPE=’PROCEDURE’

Happy Happy Joy Joy…

Leave a Reply

Your email address will not be published. Required fields are marked *