SQL Server: Error 262 SHOWPLAN permission denied in database

I have created few users on my development Database Server and provided basic permission to use our development database.

I have found that some of the user can not run a query along with execution plan and if they are trying to run a query by pressing Ctrl + M, SQL Server generates below error.

You can solve this problem by adding below additional permission.

After this permission,the user can execution queries with execution plan.

Anvesh Patel

Leave a Reply

1 Comment on "SQL Server: Error 262 SHOWPLAN permission denied in database"

Notify of
avatar
Sort by:   newest | oldest | most voted
laris
Guest

WONDERFUL Post.thanks for share..extra wait .. ā€¦

wpDiscuz