All gists matching topic mssql

1	DECLARE @user NVARCHAR(100) = N'your-resource-group-or-email';
2
3	CREATE USER [@user] FROM EXTERNAL PROVIDER;
4	ALTER ROLE db_datareader ADD MEMBER [@user];
5	ALTER ROLE db_datawriter ADD MEMBER [@user];
6	ALTER ROLE db_ddladmin ADD MEMBER [@user];
7	GO