Skip to main content
Solved

How to make an IAM user db_owner

E
Moderator
Forum|alt.badge.img+17

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

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

View original
    Did this topic help you find an answer to your question?

    3 replies

    E
    Moderator
    Forum|alt.badge.img+17
    • Erwin Ekkel
    • Author
    • Moderator
    • 761 replies
    • Answer
    • May 24, 2023

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

    Robert Jan de Nie
    Thinkwise blogger
    Forum|alt.badge.img+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.

    E
    Moderator
    Forum|alt.badge.img+17
    • Erwin Ekkel
    • Author
    • Moderator
    • 761 replies
    • June 5, 2023

    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.

    Reply


    Terms & ConditionsCookie settings

    Cookie policy

    We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

     
    Cookie settings