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 Security2
SHOWPLANPermission and Transact-SQL Batches2