We have a large number of Amazon RDS virtual SQL servers
Currently administering users on them is a manual task as they are not domain connected and to do so in with an Amazon hosted domain is crazy expensive 😞
I know if it were a "real" SQL server there is a workaounnd that has JC sync users down to a windows user group on the machine and from there you make that a member of a usergroup in SQL server
However that is not an option for us as you don't get direct access to the underlying server.
So, is there, or is there plans for, a mechanism to sync JC users into SQL as native users? (I know the SQL to add, remove, change users has existed for decades)
So we do have an AWS IAM integration. Would this work for you? https://jumpcloud.com/support/integrate-with-aws-iam-identity-center
Let me know if what you're looking for isn't covered by this integration. 🙂
Sadly not, IAM integration for RDS is just for mysql, postgres and aurora
A quick look around the web will bring up lots of SQL scripts for adding/removing/listing users/roles, changing passwords etc so I could imagine that your dev's could use them and reuse some of your existing user-sync code.
...and I'm back with an update. Unfortunately it looks like a custom script is the only option right now but our Professional Services can help with that if you need: https://jumpcloud.com/professional-services/pse
I'm not sure about the feature being built in though but you can put in a feature request if you'd like: https://jumpcloud.com/support/request-features