SHOWPLAN permission denied in database

Error message:

SHOWPLAN permission denied in database 'DBNAME'

Solution:

Grant permission of SHOWPLAN to the user:

USE DBNAME

GO

GRANT SHOWPLAN TO USERNAME

GO