Shulou(Shulou.com)06/01 Report--

SELECT 'GRANT EXECUTE ON [dbo]. [' + name +'] TO [user]'AS t_sql

FROM sys.procedures

The resulting script can be executed in batch directly:

GRANT EXECUTE ON[dbo] .[sp1] TO [user]

GRANT EXECUTE ON[dbo] .[sp2] TO [user]

GRANT EXECUTE ON[dbo] .[sp3l] TO [user]

GRANT EXECUTE ON[dbo] .[sp4] TO [user]

GRANT EXECUTE ON[dbo] .[sp5] TO [user]

GRANT EXECUTE ON[dbo] .[sp6] TO [user]

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.