MongoDB - How to add findandmodify privilege to a user

Question

In my application I am using MongoDB as the database and Express + Mongoose for handling the codes. I have added a user to the database and given the readWrite role for the user, now I can fetch the data from the database. But when I am trying to insert a collection using the save function in Express + Mongoose I got the following error message and I couldn't find how to add the findandmodify privilege to the user.

 {"name":"MongoError",
   "ok":0,
   "errmsg":"not authorized on od-database to execute  command { findandmodify: \"identitycounters\", 
   query: {
      field: \"id\",  
      model: \"Products\" },
   new: 1 , 
   remove: 0, 
   upsert: 0,
   update: { $inc: { count: 1 } } }","code":13}

Please help me.

Answer 1

I test one user with readWrite role to connect mongoDB do the save and findAndModify operation on non-system document, both of them could be done successfully.

Please make sure

• The correct username and password to connect the db in the mongoose.createConnction or mongoose.connect.
• This user does exist in the db.system.users with readWrite role.
• The readWrite user only can modify data on all non-system collections the system.js collection