emildr revised this gist 2 months ago. Go to revision
1 file changed, 7 insertions
azure_mssql_user.sql(file created)
| @@ -0,0 +1,7 @@ | |||
| 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 | |
Newer
Older