During one of my recent training class when I asked students to check the execution plan using (can be enabled using CTRL+M), they received error as following.
Msg 262, Level 14, State 4, Line 1
SHOWPLAN permission denied in database ‘AdventureWorks’.
This is quite common that now all the developers have admin rights. It was very easy to fix this issue.
GRANT SHOWPLAN TO UserName
Just run above statement in the database where user is getting error and he will be able to see the query execution plan without any issue.
Reference: Pinal Dave (http://blog.SQLAuthority.com),