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.
+1
A:
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:
Enrico Campidoglio
2010-06-14 10:09:35
Thank you very much! Actually I was looking for this (found from your link): "You cannot use SQL Server Management Studio to grant permissions on system stored procedures or system functions. Use GRANT Object Permissions instead."
atricapilla
2010-06-14 10:23:40