Does MongoDB getUsers() and SHOW command fulfil the same purpose?

MongoDBDatabaseBig Data Analytics

Both the getUsers() method and SHOW command can be used to list all users in the Mongo shell.

Case 1 − Using getUsers()

The syntax is as follows −

db.getUsers();

Case 2 − Using show command

The syntax is as follows −

show users;

Let us implement both the syntaxes in order to list all users in the Mongo shell.

Case 1 − The first query is as follows −

> db.getUsers();

The following is the output −

[
   {
      "_id" : "test.John",
      "user" : "John",
      "db" : "test",
      "roles" : [
         {
            "role" : "readWrite",
            "db" : "test"
         },
         {
            "role" : "dbAdmin",
            "db" : "test"
         }
      ],
      "mechanisms" : [
         "SCRAM-SHA-1",
         "SCRAM-SHA-256"
      ]
   },
   {
      "_id" : "test.admin",
      "user" : "admin",
      "db" : "test",
      "roles" : [
         {
            "role" : "root",
            "db" : "admin"
         }
      ],
      "mechanisms" : [
         "SCRAM-SHA-1",
         "SCRAM-SHA-256"
      ]
   }
]


Case 2 − The second query is as follows −

> show users;

The following is the output −

{
   "_id" : "test.John",
   "user" : "John",
   "db" : "test",
   "roles" : [
      {
         "role" : "readWrite",
         "db" : "test"
      },
      {
         "role" : "dbAdmin",
         "db" : "test"
      }
   ],
   "mechanisms" : [
      "SCRAM-SHA-1",
      "SCRAM-SHA-256"
   ]
}
{
   "_id" : "test.admin",
   "user" : "admin",
   "db" : "test",
   "roles" : [
      {
         "role" : "root",
         "db" : "admin"
      }
   ],
   "mechanisms" : [
      "SCRAM-SHA-1",
      "SCRAM-SHA-256"
   ]
}
raja
Published on 29-Mar-2019 10:21:49
Advertisements