SQL Server: Is there a way to provide execution using a graphical interface?

Question

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

Answer 1

Check Microsoft SQL Server Management Studio .

This is part of the SQL Server client toolkit, but there is also a free version called Microsoft SQL Server Management Studio Express .

Related Resources:

• Granting Permissions for a Stored Procedure (SQL Server Management Studio)
• Permissions (SQL Server Database Engine)

Answer 2

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

After the database properties windows are displayed, follow steps 1 through 4 and click OK .

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