emildr / Azure MSSQL User Creation
0 Favoriten
0 Forks
1 Dateien
Zuletzt aktiv 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 |
Neuer
Älter