Saturday, August 4, 2018

User Management commands


user add:


db.auth({"user”:”dbtest”,”pwd”:”ChangeMe”});

db.createUser(
   {
     user: "dbtest",
     pwd: "ChangeMe",
     "roles" : [
{
"role" : "clusterAdmin",
"db" : "admin"
},
{
"role" : "appDBARole",
"db" : "admin"
}
]
  }
)


db.createUser(
   {
     user: "dbtest",
     pwd: "ChangeMe",
     "roles" : [
{
"role" : "clusterMonitor”,
"db" : "admin"
}
]
  }
)


use $external
db.createUser({
"user" : "abc",
"roles" : [
{
"role" : "publicRole",
"db" : "admin"
},
{
"role" : "appReadRole",
"db" : "pdb01"
}
]
})


db.system.users.find({"db":"$external",_id:"$external.dm_admin"})


db.runCommand({ usersInfo: { user: “dm_admin”,db:"admin" } })

Current user:

db.runCommand({connectionStatus : 1})


Grant additional Role to user


show users or
db.system.users.find({user:”dpxabc"})

prod => db.grantRolesToUser( "dm_admin", ["clusterAdmin"])

non-prod

db.grantRolesToUser( "dm_read", ["clusterMonitor"])
db.grantRolesToUser( "dm_write", ["clusterMonitor"])
db.grantRolesToUser( "dm_read", [{ role: "read", db: "local"}])

db.grantRolesToUser( "dm_write", [{ role: "read", db: "local"}])

No comments:

Post a Comment