Uncategorized

General availability: Microsoft Purview DevOps policies for Azure SQL Database

DevOps policies, a type of Microsoft Purview access policies, allow you to manage access to system metadata on data sources that have been registered for Data use management in Microsoft Purview. This feature enables IT/DevOps personnel to ensure that their critical database estate is healthy, performing to expectations and is secure.  

You can author access policies through Microsoft Purview experience and then apply them to Azure SQL Database data sources individually or at scale, without the need to directly connect to databases or to explicitly create logins or users on a server. In this release the SQL Performance Monitor, and SQL Security Auditor roles are eligible for assignment. 

Learn more