charipg (5/5/2015)
i tried with both scripts, both scripts returns only one grant statement, but it should return more grant statements.
What does this query return?
😎
SELECT 'grant execute on ' +
QuoteName(specific_schema) + '.' +
QuoteName(specific_name) + ' To [AD\ABCD];' + CHAR(13) + CHAR(10)
from information_schema.routines
WHERE routine_type='PROCEDURE' and routine_schema='MRP'