Useful for letting developers see what a proc does, without permissions to mess it up -
select 'GRANT VIEW DEFINITION ON [dbo].['+routine_name+'] TO [Domain\User]' from information_schema.routines where routine_type = 'procedure' --and routine_name like 'usp%'
No comments:
Post a Comment