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♦

StackExchange Database Administrators Q#114786, answer score: 9