SQL Server：有没有办法使用GUI授予执行权限？

Is there a way to grant execute permissions for a role or a user using GUI (not T-SQL)? I'm using SQL Server 2008 SP1.

有没有办法使用GUI(而不是T-SQL)为角色或用户授予执行权限?我正在使用SQL Server 2008 SP1。

2 个解决方案

#1

Check out Microsoft SQL Server Management Studio.

查看Microsoft SQL Server Management Studio。

It is part of the SQL Server Client Tools package but there's also a free version called Microsoft SQL Server Management Studio Express.

它是SQL Server客户端工具包的一部分,但也有一个名为Microsoft SQL Server Management Studio Express的免费版本。

Related resources:

• How to grant Permissions on a Stored Procedure (SQL Server Management Studio)

如何在存储过程上授予权限(SQL Server Management Studio)

• Permissions (SQL Server Database Engine)

权限(SQL Server数据库引擎)

#2

Yes, there is a way. Use Permissions page of Database Properties window.

Once database properties windows is displayed, follow steps 1-4 and press OK.

显示数据库属性窗口后,按照步骤1-4并按“确定”。

Using steps A, B you can verify it is creating exactly the expected GRANT EXECUTE TO command.

使用步骤A,B,您可以验证它是否正在创建预期的GRANT EXECUTE T​​O命令。