Determining MongoDB Integration Permissions and User Roles

Original Slack Thread

Hi all, do we know what perms does the user need for mongodb integration? Is there anything specific that we need to keep in mind before we create a user?

<@U04NUK1721W> could you confirm on this? I think this information does not present on our doc.

yeah unfortunately there is no specification mentioned in the doc

Anything on this? cause I am getting this error:
pymongo.errors.OperationFailure: not authorized on core to execute command

the user has read-only perms on the cluster

<@U04N9PYJBEW> is this something you can help with?

Hi <@U059V4WG1GQ>, sorry for the delay in response. We’re changing how we respond to slack questions internally and so I’ve been having trouble seeing which threads I’ve been mentioned on. I’m not too familiar with this source, <@U01GZEETMEZ> do you remember what’s required here?

Looking at what we call, I think you will need the read role on any databases you want to ingest. Please let me know if that seems insufficient.

the user I am using does have read role but I am still getting this error. Looks like datahub is trying to add a column ?

Can you paste the full log

Sure. Here’s a log fileattachment

Ah I see, we create a temporary field. Then you’ll need read + write roles

thanks. will this have any effect of the health of the cluster?

I wouldn’t think so, but again I’m not an expert on this source