This article is half-done without your Comment! *** Please share your thoughts via Comment ***
I created few users in my development Database Server and provided basic permissions.
I found that some of the users cannot run a query along with execution plan and if they are trying to run a query by pressing Ctrl + M, SQL Server generates a below error.
1 2 |
Msg 262, Level 14, State 4, SHOWPLAN permission denied in database. |
You can solve this problem by adding below additional permission.
1 2 |
GRANT SHOWPLAN TO New_User GO |
Once you grant the above permission, the user can execute the queries with the execution plan.