SQL Server: Msg 262, SHOWPLAN permission denied in database

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

Feb 16, 2018Anvesh Patel

Database Engineer