Synapse Dedicated SQL Pool
Connect to your database using a tool like the Microsoft SQL Server Management Studio, and execute the following query. Note that the <entra_sp_name> should be replaced with the name of the Microsoft Entra Managed Identity or the Microsoft Entra Service Principal, depending on which authentication method you are using.
CREATE USER [<entra_sp_name>] FROM EXTERNAL PROVIDER;
EXEC sp_addrolemember 'db_datareader', '<entra_sp_name>';
EXEC sp_addrolemember 'db_datawriter', '<entra_sp_name>';
Last updated