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 challenges too so I would like to hear what their solution are/were.
Best answer by Mark Jongeling
The information I needed was the login name, authentication type (RDBMS) and user group.