Allowing non-sysadmin users to see SQL Server execution plans 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:


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♦