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
Community Wiki answer generated from question comments
Yes this is possible. See:
- Syntax for Granting, Denying, and Revoking the
SHOWPLAN
Permission1 2 - Showplan Security2
SHOWPLAN
Permission and Transact-SQL Batches2
1 Contributed by Mark Sinkinson
2 Contributed by Aaron Bertrand♦