SQL Server - Required Permissions For Executing Stored Procedures With SHOWPLAN ON
The user must have permission to run the stored procedure at the minimum to get the showplan information.  You can just grant the user access to run the one stored procedure and not all of them.

GRANT EXECUTE ON sp_name TO username;