See / setup a user with MongoDB Compass?

Question

With MongoDB Compass is it possible to see users for a database or create new ones?

score 31 · Accepted Answer · answered Oct 27 '17 at 10:37

31

Ive managed it on the command line with:

mongo
use (my database name)
db.createUser( { user: "myuser", pwd: "password", roles: ["readWrite"] })

However I would still much prefer a GUI to do this.

answered Oct 27 '17 at 10:37

Evanss

23,390
94
282
505

score 3 · Answer 2 · answered Oct 28 '22 at 12:29

If you're trying to create a new DB with a user that "owns" that DB (i.e. has read/write and admin commands for that DB), here's how to do that using only MongoDB Compass:

Open up MongoDB Compass and connect with your admin user.
Create a new DB with the "+" button at bottom of the DB list.
Click the MONGOSH shelf/tab at the bottom of the screen and paste this:

use NAME_OF_NEW_DB

db.createUser(
  {
    user: "NAME_OF_NEW_USER",
    pwd: "NEW_USER_PASSWORD",
    roles: [ { role: "dbOwner", db: "NAME_OF_NEW_DB" } ]
  }
)

Other roles are explained in the MongoDB docs.

score 2 · Answer 3 · answered Feb 28 '20 at 12:41

2

No, it isn't (at least until version 1.20.4 of Compass)

answered Feb 28 '20 at 12:41

MauriRamone

469
1
3
21

1

still can't as of version 1.31.2 – rugby2312 Jun 07 '22 at 10:53

score 1 · Answer 4 · answered Jun 16 '20 at 09:59

If I run a command in CLI after made up a user. I can see that by using this command.

db.system.users.find().pretty()
{
        "_id" : "admin.admin",
        "userId" : UUID("****"),
        "user" : "admin",
        "db" : "admin",
        "credentials" : {
                "SCRAM-SHA-1" : {
                        "iterationCount" : 10000,
                        "salt" : "***",
                        "storedKey" : "***",
                        "serverKey" : "***"
                },
                "SCRAM-SHA-256" : {
                        "iterationCount" : 15000,
                        "salt" : "***",
                        "storedKey" : "***",
                        "serverKey" : "***"
                }
        },
        "roles" : [
                {
                        "role" : "root",
                        "db" : "admin"
                }
        ]

But I can't see the 'system.users' collection in the Compass client. I think, the Compass does not support this the listing and creating user features.

But, if you use other client (eg. TablePlus), You can see those hidden documents

See / setup a user with MongoDB Compass?

4 Answers4