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 |
上一页
下一页