For some external scripts it's mandatory to be db_owner of the end product database. Is there an option within IAM to create the user as db_owner?
Answer
How to make an IAM user db_owner
Best answer by Erwin Ekkel
This is currently not possible within IAM. If you feel this could benefit other developers feel free to create an idea for this.
This is currently not possible within IAM. If you feel this could benefit other developers feel free to create an idea for this.
+6I'm sure there is ways around granting db_owner in order to run external scripts. Especially anything coming from the ‘outside world’, should be running with minimal privileges.
Sure, you could grant permission to run external scripts, but as far as I know, it's not possible through IAM.
The easiest workaround would probably be to rebuild this using a process flow or system flow. This way, only the indicium user would need the appropriate database rights.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.