https://pulumi.com logo
Title
i

important-london-46196

09/30/2022, 7:28 AM
Hello, team! Does Pulumi have the functionality to manage users for MSSQL database (not the server admin user)? If not, do you have any ideas to implement it on your own?
βž• 1
r

ripe-russia-4239

09/30/2022, 8:37 AM
There's no provider for this, but
Pulumi.Command
has been presented as an option for this sort of thing in the past.
πŸ‘€ 1
c

chilly-analyst-14900

09/30/2022, 11:50 AM
Is there any guidance on best practice for
Pulumi.Command
in cases like this? Ex: Would it make sense to actively set the MSSQL database as Parent resource in this case, or would DependsOn=MyDataBaseResource be sufficient?
r

ripe-russia-4239

09/30/2022, 2:07 PM
As I understand them: β€’ The Parent controls both the dependency resolution and the location of the resource in the stack's tree β€’ DependsOn only links the two resources for dependency resolution I think Parent therefore places stronger restrictions on deployment ordering than DependsOn. DependsOn is probably sufficient, in this scenario, but Parent better conveys the container->object relationship IMO.
i

important-london-46196

10/03/2022, 7:45 AM
The problem is not to create a workaround, but suggestion to implement this functionality. Therefore where should it be posted or who should be mentioned?
r

ripe-russia-4239

10/03/2022, 8:15 AM
As best I can tell, Pulumi don't take requests to implement new providers, but will accept new providers once implemented (and might offer some support in implementing them too). There's a sort of "getting started" document here. If there's a Terraform provider for SQL Server already, then you can get a leg up implementing one for Pulumi using the pulumi-terraform-bridge. You might also find some inspiration in the MySQL and PostgreSQL providers.
βœ… 1
I also have a need for this, so am willing to lend a hand with the implementation if that would be helpful ☺️
βž• 1
FWIW, I made a small start on this provider earlier today. I've done the scaffolding tasks in a private repo, and I'm happy to share this with collaborators. I haven't made it public because I don't want people stumbling across it thinking a SQL Server provider exists already πŸ˜… My golang is ... not strong ... so I can't necessarily guarantee anything more than a snail's rate of progress 😁
i

important-london-46196

10/07/2022, 8:29 AM
I wish it was on C#πŸ˜…