select 'GRANT VIEW DEFINITION ON ' + quotename(specific_schema) + '.' + quotename(specific_name) + ' TO ' + 'BOB' from INFORMATION_SCHEMA.routines where routine_type = 'PROCEDURE'
No comments:
Post a Comment