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:
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
No comments:
Post a Comment