The new access policies feature provides data owners capability to author access policies through Microsoft Purview data-governance service experience and then apply them to Azure SQL Database data sources individually or at scale. With this approach you are empowered to assign permissions to Azure Active Directory users at a scale without the connection to databases or the need to explicitly create logins or users on a server. In this release the following server roles are eligible for assignment: Data Reader, Performance Monitor, and Security Auditor.
Learn more.