CODEWITHSUNDEEP
sql-serversql-server-2008permissions
atricapilla
atricapilla

Reputation: 2640

SQL Server: Is there a way to grant execute using 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.

Upvotes: 7

Views: 11042

Answers (2)

miroxlav
miroxlav

Reputation: 12204

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.

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

enter image description here

Upvotes: 9

Enrico Campidoglio
Enrico Campidoglio

Reputation: 59983

Check out 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.

Related resources:

Upvotes: 2

Related Questions