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]
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/22996654/viewspace-2149883/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
