azure_mssql_user.sql
· 244 B · MySQL
Raw
DECLARE @user NVARCHAR(100) = N'your-resource-group-or-email';
CREATE USER [@user] FROM EXTERNAL PROVIDER;
ALTER ROLE db_datareader ADD MEMBER [@user];
ALTER ROLE db_datawriter ADD MEMBER [@user];
ALTER ROLE db_ddladmin ADD MEMBER [@user];
GO
| 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 |
| 8 |