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 ?


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, privacy policy and cookie policy

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