USE <YourDBName> GRANT VIEW DEFINITION TO <YourUser> GO
USE <YourDBName> GRANT SHOWPLAN TO <YourUser> GO