How can I create a RDBMS user with roles from the end product? For a project, we would like to be able to create RDBMS users from inside the end product. For context, we are using a configurator inside the end product from where we are able to enter the first employee of a new company. We would like to make that employee be able to log in after we finished the configuration.
I know which steps to take if I do it by hand; namely: sync my application to IAM, apply the roles to the database, create an IAM user, connect the user to a role, apply the user rights to the end product database and IAM database. Then the user is able to log in.
But now I would like the end product to do this process. I'm able to create an user in IAM and give the user the right user group. Now I'm stuck because I can't apply the user rights to the end product database and IAM database. I noticed these tasks aren't Stored Procedures on the SQL database.
So the question is, how can I make this work? I heard that in other projects people have run into these challeng