Azure SQL Database
An Azure relational database service.
6,020 questions
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
How to provide permission for SHOWPLAN to access the execution plan in Azure SQL DB.
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.
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?