Find the GRANT in the Procedure Haystack

15_The_Superhuman_Gambit

Your hero for the day!

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

A Lot of errors coming from GRANT EXEC inside stored procedures that did not 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 *

This site uses Akismet to reduce spam. Learn how your comment data is processed.