How to make an IAM user db_owner

  • 23 May 2023
  • 3 replies

Userlevel 6
Badge +16

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?


Best answer by Erwin Ekkel 24 May 2023, 13:06

View original

3 replies

Userlevel 6
Badge +16

This is currently not possible within IAM. If you feel this could benefit other developers feel free to create an idea for this. 

Userlevel 5
Badge +5

I'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.

Userlevel 6
Badge +16

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.