Sqlserver 2014 用脚本批量赋予用户可以执行存储过程的权限
SELECT 'GRANT EXECUTE ON[dbo].[' + name + ']TO [user]' AS t_sql
FROM sys.procedures
得到的脚本直接批量执行即可：
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]
FROM sys.procedures
得到的脚本直接批量执行即可：
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]
声明：本站所有文章资源内容，如无特殊说明或标注，均为采集网络资源。如若本站内容侵犯了原著者的合法权益，可联系本站删除。
