emildr / Azure MSSQL User Creation
0 喜歡
0 分支
1 檔案
最後活躍 2 months ago
| 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 |
上一頁
下一頁