Posts Tagged ‘SQL DBA’

SQL Error – SHOWPLAN permission denied in database

August 10, 2016 Leave a comment


So, you are working on a SQL Query Performance issue in your Production environment, but you just have read access and can just execute SELECT statements to check the data.

But when you try to check what execution plan that query is creating/using you are getting blocked as you don’t have sufficient privileges for the same, and getting this error:

Msg 262, Level 14, State 4, Line 283
SHOWPLAN permission denied in database ‘AdventureWorks2014’.


For checking Execution plans you don’t need to have admin privileges, just granting access on SHOWPLAN setting will work for you.

So, you can your DBA to grant you access by using below query:

USE AdventureWorks2014

GRANT SHOWPLAN TO user_name -- replace user_name here

Categories: SQL Errors Tags: , ,