Sql Server : How to GRANT permissions to view Execution Plans

Quick one today:

For the most part, permissions in production are tightly configured (hopefully). So any new permissions must need to go through certain approval process. Recently, we had to assign this new level permissions to some specific individuals. For other permissions and examples see this post

• Permissions to view Execution Plans

--
--
--
USE TESTDB
GO
GRANT SHOWPLAN ON DATABASE::TestDB TO [Test_Login]
GO

Tip: There are some good posters from Microsoft to help understand this complicated permissions hierarchy.

Any general questions regarding permissions, Microsoft has a great BoL article here.

Note: It is obvious, but this question keeps coming up frequently, so a quick note on it here. One cannot GRANT, REVOKE  or DENY permissions on your own account.

 

Hope this helps,

_Sqltimes

Read Full Post »