Blog Post

SQL Server Blog
1 MIN READ

Using Query Store with least privileges instead of db_owner to achieve Separation of Duties

AndreasWolter's avatar
AndreasWolter
Icon for Microsoft rankMicrosoft
Aug 07, 2019

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.0
No CommentsBe the first to comment