Can't query MongoDB with readonly access user - write access is required

Queries and Resources
, ,
1

I have created a dedicated user for retool which has readonly access to my MongoDB on Atlas since I'd like only to fetch data from the DB, but the query fails with error: "datasource run failed. message:"user is not allowed to do action [find] on [mydb.mycollection]" and it only works if I set access to "readWriteAnyDatabase"

I don't want to provide write access to this user, any other solution?

2

Hey @Tom_Keidar!

Are you able to run your find query outside of Retool? Doing some digging on the MongoDB error you mentioned and I've so far only seen solutions that require write access (example).