Channels
announcements
automation-api
aws
azure
blog-posts
built-with-pulumi
cloudengineering
cloudengineering-support
content-share
contribex
contribute
docs
dotnet
finops
general
getting-started
gitlab
golang
google-cloud
hackathon-03-19-2020
hacktoberfest
install
java
jobs
kubernetes
learn-pulumi-events
linen
localstack
multi-language-hackathon
office-hours
oracle-cloud-infrastructure
plugin-framework
pulumi-ai
pulumi-cdk
pulumi-cloud
pulumi-crosscode
pulumi-deployments
pulumi-kubernetes-operator
pulumiverse
python
registry
status
testingtesting123
testingtesting321
typescript
welcome
workshops
yaml
Title
m
mammoth-train-70005
02/26/2020, 10:38 AMHi, is there a pulumi “native” way to add AAD User/Groups to an Azure SQL Database? The azure/sql provider seems not providing such functionality, only on the Server Level i can set the AAD Administrator Or is it simpler to run a tool which runs the SQL Commands?
b
better-rainbow-14549
02/26/2020, 10:59 AMwe made a "dynamic provider" to create users and apply schemas because we couldn't find anything
it just generates commands and runs them with a tool but it lets us keep track of which users have been created in a pulumi way, and delete them etc
m
mammoth-train-70005
02/26/2020, 2:18 PMBut for the SQL Connection I have to “Fallback” to something like the npm package mssql to connect to azure SQL? And can hopefully use the identity of
az loginb
better-rainbow-14549
02/26/2020, 4:20 PMyeah we used a custom tool but something like that would work
the only issue is it might capture the source of the mssql npm package into the state file too... not sure about that
happy to send you an example of our dynamic resource class
m
mammoth-train-70005
02/28/2020, 9:31 PMOh, that would be fantastic!