Search code examples
mongodbmongodb-roles

MongoDB not authorized for query - code 13

In MongoDB 2.6.1 I've setup a user with dbAdmin rights:

{
        "_id" : "mydbname.myusername",
        "user" : "myusername",
        "db" : "mydbname",
        "credentials" : {
                "MONGODB-CR" : "<some credentials>"
        },
        "roles" : [
                {
                        "role" : "dbAdmin",
                        "db" : "mydbname"
                }
        ]
}

When I use the mongo shell to connect to the database (using -u and -p on command line) and run a query like this: 

db.mycollectionname.find()

I get this error: 

error: { "$err" : "not authorized for query on mydbname.request", "code" : 13 }

Any ideas what can be happening?

So far I've tried adding every role I can find to the user but that hasn't helped.

Solution

  • You need to assign the read role to the user in question.

    The dbAdmin role does not include read access on non-system collections.