How do mongo create user as admin for any database?

437    Asked by DeepakMistry in SQL Server , Asked on Sep 30, 2022

 I am trying to create a simple user with the right permission to access any database and can do any actions. When I trying to execute the create User command I got this error:

db.createUser({ user: "mongoadmin" , pwd: "mongoadmin", roles: ["userAdminAnyDatabase", "dbAdminAnyDatabase", "readWriteAnyDatabase"]}) 2015-08-20T17:09:42.300+0000 E QUERY Error: couldn't add user: No role named userAdminAnyDatabase@new_vehicles_catalog

The problem above only happens when I enable the auth configuration and I need it.

So, How do I create a user with admin permission for any database? I want it because I configured my mongo services to use authentication connections. If I want to execute a dump of my data I have to use these authentication parameters.

Please help?

Using mongo version 3.0.5.

the service is on Amazon Linux AMI 2015.03 (HVM), SSD Volume Type - ami-1ecae776

Answered by Deepali singh

The '...Any Database' roles should be added to the admin database for the mongo create user:

use admin db.createUser({ user: "mongoadmin" , pwd: "mongoadmin", roles: ["userAdminAnyDatabase", "dbAdminAnyDatabase", "readWriteAnyDatabase"]})

Any database:

Database User Roles

Database Administration Roles

Admin database:

Cluster Administration Roles

Backup and Restoration Roles

All-Database Roles

Extra: To give different roles on different database and admin:

db.createUser({user:"replSetManager",pwd:"password",roles:[{role:"clusterManager",db:"admin"},{role:"dbOwner", db:"adminsblog"},{role:"readWrite", db:"departmentblog"},{role:"read", db:"otherblog"}]})



Your Answer

Interviews

Parent Categories