Is this possible ? On SQL Server 2012+, grant access to a non sysadmin user to see the execution plans ? And can this be done for selected databases only ?


1 Answer 1


Community Wiki answer generated from question comments

Yes this is possible. See:

1 Contributed by Mark Sinkinson
2 Contributed by Aaron Bertrand♦

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.