SQL ORACLE
One Orange Chip
Points: 27807
More actions
July 10, 2009 at 9:09 am
#212304
What permission should we grant to view execution plan?
Many thanks in advance.
Steve Jones - SSC Editor
SSC Guru
Points: 736602
July 10, 2009 at 9:50 am
#1023165
I think that if you can execute the query you can view the plan.
K. Brian Kelley
Points: 114642
July 13, 2009 at 7:15 am
#1023853
If it's 2005/2008, you need the SHOWPLAN permission at the database level. You also need the ability to execute the query. This is for the actual execution plan returned from SQL Server.
More here:
Books On-line: Showplan Security (SQL Server 2005)
K. Brian Kelley@kbriankelley
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply