SQL Server - SHOWPLAN permission denied in database - Error - Msg 262, Level 14, State 4, Line 1

When a User with minimum privilege try to view the execution plan for a query, below error will throwed:

Msg 262, Level 14, State 4, Line 1
SHOWPLAN permission denied in database 'AdventureWorks2012'.

To resolve the error:


Database administrator have to grant the SHOWPLAN permission using below syntax:

GRANT SHOWPLAN TO [Sathya-PC\Sathya]
GO

SELECT * FROM Sys.sysmessages
WHERE msglangid = 1033
AND error = 262

SELECT * FROM Sys.messages
WHERE language_id = 1033
AND message_id = 262

Reference :

• http://technet.microsoft.com/en-us/library/ms175117(v=sql.105).aspx
• http://msdn.microsoft.com/en-IN/library/ms178569.aspx

See Also :

• SQL Server Errors List