Sql Server : How to GRANT permissions to view Execution Plans
- Posted by Sqltimes
- On March 3, 2010
- 0 Comments
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
1
2
3
4
5
6
7
|
-- -- -- 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,
0 Comments