This article is half-done without your Comment! *** Please share your thoughts via Comment ***
If you are SQL DBA and managing database users, you might be facing this error.
Mostly, when you created a read-only database user then additionally you should give SHOWPLAN permission.
If the user is interested in checking the SQL Queries Execution Plan, it requires SHOWPLAN permission.
Error:
1 2 |
Msg 262, Level 14, State 4, Line 9 SHOWPLAN permission denied in database 'database_name'. |
Solution:
1 2 |
GRANT SHOWPLAN TO User_Name GO |
Leave a Reply