How to provide permission for SHOWPLAN to access the execution plan in Azure SQL DB

Vijay Kumar 2,016 Reputation points
2022-04-21T16:39:18.937+00:00

How to provide permission for SHOWPLAN to access the execution plan in Azure SQL DB.

Azure SQL Database
0 comments No comments
{count} vote

Accepted answer
  1. Alberto Morillo 33,001 Reputation points MVP
    2022-04-21T16:57:43.103+00:00

    To grant a user show plan permission:

    GRANT SHOWPLAN TO TheUserLogin;
    

    Users who have SHOWPLANpermission can view queries that are captured in Showplan output. These queries may contain sensitive information such as passwords. Therefore, it is recommended that you only grant these permissions to users who are authorized to view sensitive information.

    3 people found this answer helpful.
    0 comments No comments

1 additional answer

Sort by: Most helpful
  1. Will Woodbery 1 Reputation point
    2022-07-01T15:12:49.15+00:00

    Can the estimated plan feature be turned off in ADS for cases when the user doesn't have SHOWPLAN but needs to query the database?

    0 comments No comments