How to Configure a MotherDuck Service User with Insert-Only Permissions (No DML)

Can I configure a motherduck service user to only have insert permissions i.e. no DML?

· Sorted by Oldest

Yana C.
·
·
Hey Georg H., could you clarify your use-case a little? Just to make sure we're on the same page, INSERT is part of DML; did you mean insert but no update/delete (append-only)?
Georg H.
·
·
Yes
Georg H.
·
·
Line in Kafka publish only
Yana C.
·
·
Unfortunately, that would not be possible at the moment 😔 I can flag it as a feature request, though, would you like me to?
Georg H.
·
·
yes please!
Yana C.
·
·
Georg H. will do so 🙌. I would also be happy to hear more about your planned implementation / use-case if you want to elaborate further!
Georg H.
·
·
well a bit like kafka sometimes you have clients who only should push data - but not mutate any existing stuff
Georg H.
·
·
being able to scope this would be useful
🙂‍↕️1

Yana C.
·
·
Hey Georg H., could you clarify your use-case a little? Just to make sure we're on the same page, INSERT is part of DML; did you mean insert but no update/delete (append-only)?
Georg H.
·
·
Yes
Georg H.
·
·
Line in Kafka publish only
Yana C.
·
·
Unfortunately, that would not be possible at the moment 😔 I can flag it as a feature request, though, would you like me to?
Georg H.
·
·
yes please!
Yana C.
·
·
Georg H. will do so 🙌. I would also be happy to hear more about your planned implementation / use-case if you want to elaborate further!
Georg H.
·
·
well a bit like kafka sometimes you have clients who only should push data - but not mutate any existing stuff
Georg H.
·
·
being able to scope this would be useful
🙂‍↕️1