Share via

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

Vijay Kumar 2,031 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
Accepted answer
  1. Alberto Morillo 33,426 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

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  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