Sql-docs: Required Permissions are incorrect on Azure SQL Database.

[paulmchenry]

The required permissions section says that INSERT, UPDATE, and DELETE permissions are required on the query store catalog views, however, these cannot be changed in Azure SQL Database. Attempting to do so returns the following error:

Msg 4629, Level 16, State 10, Line 19 Permissions on server scoped catalog views or system stored procedures or extended stored procedures can be granted only when the current database is master.

This error would also seem to be incorrect, as it is not the reason the permissions cannot be changed. If attempting to update the permissions on the master DB then the following error is thrown:

Msg 40574, Level 16, State 1, Line 1 Permissions for system stored procedures, server scoped catalog views, and extended stored procedures cannot be changed in this version of SQL Server.

I'm not sure if the behaviour should be different or not, but at the moment the documentation suggests this should be possible.

---

Document Details

⚠ Do not edit this section. It is required for docs.microsoft.com ➟ GitHub issue linking.

• ID: 10814457-71c9-fd00-809c-c3c0139a731a
• Version Independent ID: 6bd88317-ccfb-dbb8-81c8-c63610b5bb95
• Content: sp_query_store_force_plan (Transact-SQL) - SQL Server
• Content Source: docs/relational-databases/system-stored-procedures/sp-query-store-force-plan-transact-sql.md
• Product: sql
• Technology: system-objects
• GitHub Login: @stevestein
• Microsoft Alias: sstein

[MightyPen]

@paulmchenry Hello Paul, Thank you for submitting this Issue #2490 . The Issue has been Assigned for investigation.

[VanMSFT]

@paulmchenry - Hi Paul, the documentation has changed to reflect that the ALTER permission is needed on the database. Please let us know if you have any concerns. Thanks for reporting this issue!

please-close