What permission should we grant to view an execution plan?

Apart form db_datareader  we have to grant  SHOWPLAN permission at the database level.

USE DatabaseName
Go

Grant SHOWPLAN to [username]

Note: sysadmin, dbcreator or db_owner ‘s can see the execution plan with out showplan permission.