SQL SERVER 添加存储过程权限

可查看定义(design)

USE [DB Name]
GRANT VIEW DEFINITION ON SCHEMA::[dbo] TO [vvull]
GO

可执行(exec)

USE [DB Name]
GRANT EXECUTE ON SCHEMA::[dbo] TO [vvull]
GO