When using the Query Store in a production environment, sometimes customers need to delegate very specifically who can do what in terms of Performance Analysis and/or Tuning.
In this article we will demonstrate, how customers can segregate the typical activities around the Query Store and delegate minimal sets of permissions to groups of users that are mandated to certain tasks.
The article is published here on the Azure SQL Blog: Using Query Store with least privileges instead of db_owner to achieve Separation of Duties
Updated Aug 08, 2019
Version 2.0AndreasWolter
Microsoft
Joined January 21, 2019
SQL Server Blog
Follow this blog board to get notified when there's new activity