I have 5 DBs and a DB user named analytics
db1
db2
db3
db4
db5
On db1 there is only one collection (col1) that can be accessed by analytics user.
For me to have this, I created a role on the db1 itself for the customized permission (hence why the authenticationDatabase is db1 and not admin)
Basically the analytics user should connect via:
mongodb://10.1.0.24:27017/?authenticationDatabase=db1
Because this is working on the machine itself.
However on the Metabase UI.
Whenever I try to save this connection it is failing.