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?

Question

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

score 6 · Accepted Answer · answered Nov 10 '14 at 18:39

6

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.

answered Nov 10 '14 at 18:39

wdberkeley

11,531
1
28
23

1

Thanks - how do I find out what the user's database is? – tadasajon Nov 10 '14 at 19:03
6

Elaborated for future readers: > use admin (or the authenticationDatabase specified during user creation) > db.getUser('current_username') – Snidhi Sofpro Feb 21 '20 at 17:20

score 0 · Answer 2 · answered Feb 24 '22 at 09:29

0

use db.getUsers(); or show users;

answered Feb 24 '22 at 09:29

Manvendra Singh

21
2

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?

2 Answers2