DECLARE @user NVARCHAR(100) = N'your-resource-group-or-email';

CREATE USER [@user] FROM EXTERNAL PROVIDER;
ALTER ROLE db_datareader ADD MEMBER [@user];
ALTER ROLE db_datawriter ADD MEMBER [@user];
ALTER ROLE db_ddladmin ADD MEMBER [@user];
GO