授权执行所有存储过程 [英] GRANT EXECUTE to all stored procedures

问题描述

以下命令是否有效地授予用户"MyUser"执行数据库中所有存储过程的权限?

Does the following command effectively give the user, "MyUser," permission to execute ALL stored procedures in the database?

GRANT EXECUTE TO [MyDomain\MyUser]

推荐答案

SQL Server 2008及更高版本:

SQL Server 2008 and Above:

/* CREATE A NEW ROLE */
CREATE ROLE db_executor

/* GRANT EXECUTE TO THE ROLE */
GRANT EXECUTE TO db_executor

仅针对用户(而非角色):

For just a user (not a role):

USE [DBName]
GO
GRANT EXECUTE TO [user]

这篇关于授权执行所有存储过程的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！