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 |
Новее
Позже