Wednesday, 22 November 2017

How to create admin and db based user in mongodb?


Admin User:

db.createUser(
    {
      user: "admin",
      pwd: "password123",
      roles: ["userAdminAnyDatabase","userAdmin","readWrite","dbAdmin","clusterAdmin","readWriteAnyDatabase","dbAdminAnyDatabase"]
    }
)

DB based User:

User who can access only a specific database.

db.createUser(
   {
     user: "myuser",
     pwd: "password123",
     roles: [ { role: "readWrite", db: "databasename" } ]
   }
);

No comments:

Post a Comment

The total number of locks exceeds the lock table size

 SHOW VARIABLES LIKE 'innodb_buffer_pool_size'; SET GLOBAL innodb_buffer_pool_size = 2147483648;  -- 2GB Note: The value is in byte...