Hi how do one go about deleting a user that was created with a trailing space?
I am connected as the admin user to a replica set, with the required permissions to drop users.
db.getUser(“admin”)
{
_id: 'admin.admin',
userId: UUID("15920e8b-3019-43cf-8938-9357699d3bf8"),
user: 'admin',
db: 'admin',
roles: [
{ role: 'userAdminAnyDatabase', db: 'admin' },
{ role: 'readWriteAnyDatabase', db: 'admin' },
{ role: 'dbAdminAnyDatabase', db: 'admin' },
{ role: 'dbOwner', db: 'admin' },
{ role: 'clusterAdmin', db: 'admin' }
],
mechanisms: [ 'SCRAM-SHA-1', 'SCRAM-SHA-256' ]
}
use admin
‘already on db admin’
db.getUsers()
users: [
{
_id: 'admin.someuser ',
userId: UUID("4ede2b9e-cb81-44cd-b2bb-6c92a078b350"),
user: 'someuser ',
db: 'admin',
roles: [Array],
mechanisms: [Array]
}
],
ok: 1,
'$clusterTime': {
clusterTime: Timestamp({ t: 1677838887, i: 923 }),
signature: {
hash: Binary(Buffer.from("0e632a7fd10df8bb9f211b0509ffdaa1eb07377b", "hex"), 0),
keyId: Long("7142600741474009090")
}
},
operationTime: Timestamp({ t: 1677838887, i: 923 })
}
when trying to drop the user containing the trailing space I get a server error.
db.dropUser('someuser ')
MongoServerError: User ‘someuser @admin’ not found