Mongo - How can I find out what roles the user I am connected as has? How can I assign a user full read-write access?

mongodb mongodb-query user-roles
jononomo picture jononomo · Nov 10, 2014 · Viewed 12.9k times · Source

I have been able to connect to my Mongo instance (which is hosted in the cloud at Compose.io -- it is an "addon" through Heroku) from my MacBook terminal command line.

However, I cannot perform any operations. Commands like "show collections" and "show users" fail with a "not authorized" error.

How can I find out what roles the user I am connected as has? Also, how can I add a user with full read-write permissions? Of course I've tried:

db.createUser({
    user: "accountUser",
    pwd: "password",
    roles: [ "readWrite", "dbAdmin" ]
})

but this command fails with couldn't add user: not authorized on my_db to execute command

Answer

wdberkeley picture wdberkeley · Nov 10, 2014

To view information about the current user, run db.getUser() on the user's database. You'll need to check with your MongoDB provider on how they've set up the security to figure out how to add the correct roles to your users.

Related questions

How to query MongoDB with "like"?

I want to query something with SQL's like query: SELECT * FROM users WHERE name LIKE '%m%' How to do I achieve the same in MongoDB? I can't find an operator for like in the documentation.

Read More
Find objects between two dates MongoDB

I've been playing around storing tweets inside mongodb, each object looks like this: { "_id" : ObjectId("4c02c58de500fe1be1000005"), "contributors" : null, "text" : "Hello world", "user" : { "following" : null, "followers_count" : 5, "utc_offset" : null, "location" : "", "profile_text_color" : "000000", "friends_count" : 11, "profile_…

Read More
Query for documents where array size is greater than 1

I have a MongoDB collection with documents in the following format: { "_id" : ObjectId("4e8ae86d08101908e1000001"), "name" : ["Name"], "zipcode" : ["2223"] } { "_id" : ObjectId("4e8ae86d08101908e1000002"), "name" : ["Another ", "Name"], "zipcode" : ["2224"] } I can currently get documents that match a specific array …

Read More