Update a Database User¶

On this page

Syntax
Example Request
- Request
- Response

Note

Groups and projects are synonymous terms. Your {GROUP-ID} is the same as your project ID. For existing groups, your group/project ID remains the same. The resource and corresponding endpoints use the term groups.

Base URL: https://cloud.mongodb.com/api/atlas/v1.0

The Atlas API uses HTTP Digest Authentication. Provide your Atlas username as the username and Atlas API key as the password as part of the HTTP request.

This endpoint requires that the Atlas user has the Owner role. To view the available Atlas users, click on Users & Teams in the left-hand navigation.

For complete documentation on configuring API access for an Atlas project, see Configure Atlas API Access.

Syntax¶

Send only those fields where you will change the value.

copy

PATCH /api/atlas/v1.0/groups/{GROUP-ID}/databaseUsers/admin/{USERNAME}

Behavior¶

You can update a user’s roles and password. Additionally, for temporary users, you can update the user’s expiration date or set the user to be permanent. You cannot update the user’s name or authentication database, which is admin. You also cannot update permanent users to be temporary.

Request Path Parameters¶

Parameter	Required/Optional	Description
`GROUP-ID`	Required.	The unique identifier for the project.
`USERNAME`	Required.	The username to update

Request Query Parameters¶

This endpoint may use any of the HTTP request query parameters available to all Atlas API resources. These are all optional.

Name	Type	Description	Default
`pretty`	boolean	Displays response in a prettyprint format.	`false`
`envelope`	boolean	Specifies whether or not to wrap the response in an envelope.	`false`

Request Body Parameters¶

Name	Description
`deleteAfterDate`	Optional ISO-8601-formatted UTC date after which Atlas deletes the user. The specified date must be in the future and within one week of the time you make the API request. To update a temporary user to be permanent, set the value of this field to `null`. Note You may include an ISO-8601 time zone designator to ensure that the expiration date occurs with respect to the local time in the specified time zone. Important You can only modify the expiration date for a user if an expiration date was specified when creating the user. You cannot assign a `deleteAfterDate` to a permanent user.
`roles`	Array of this user’s roles and the databases / collections on which the roles apply. A role allows the user to perform particular actions on the specified database. A role on the `admin` database can include privileges that apply to the other databases as well. Note The available privilege actions for custom MongoDB roles support a subset of MongoDB commands. See Unsupported Commands in M10+ Clusters for more information. Important If a user is assigned a custom MongoDB role, they cannot be assigned any other roles.
`roles.databaseName`	Database on which the user has the specified role. A role on the `admin` database can include privileges that apply to the other databases.
`roles.collectionName`	Collection for which the role applies. You can specify a collection for the `read` and `readWrite` roles. If you do not specify a collection for `read` and `readWrite`, the role applies to all collections in the database (excluding some collections in the `system.` database). Note When applied to a collection, the `read` and `readWrite` roles in Atlas differ slightly from the built-in MongoDB `read` and `readWrite` roles. In Atlas, `read` provides the following collection-level actions: collStats dbHash find listIndexes In Atlas, `readWrite` provides the same actions as `read`, as well as the following additional collection-level actions: convertToCapped createCollection createIndex dropCollection dropIndex insert remove update
`roles.roleName`	Name of the role. This value can either be a built-in role or a custom role. The following accepted values of `role` are restricted to the `admin` database: `atlasAdmin` `readWriteAnyDatabase` `readAnyDatabase` `clusterMonitor` `backup` `dbAdminAnyDatabase` `enableSharding` This role is specific to MongoDB databases managed by Atlas. The role allows the user to enable sharding on a database and to shard a collection. The following accepted values of `role` can be applied to a specific database: `dbAdmin` `read` `readWrite` The following accepted values of `role` can be applied to a specific collection: `read` `readWrite` If you do not specify a collection for the `read` and `readWrite` roles, the roles apply to all collections (excluding some `system.` collections) in the database. Note If you specify a custom role name in this field, the `roles.databaseName` field must be `admin`.
`password`	The user’s password. This field is NOT included in the entity returned from the server.

Response Elements¶

If you set the query element envelope to true, the response is wrapped by the content object.

Name	Description
`databaseName`	The user’s authentication database. A user must provide both a username and authentication database to log into MongoDB. In Atlas deployments of MongoDB, the authentication database is always the `admin` database.
`deleteAfterDate`	ISO-8601- formatted date after which Atlas deletes the user. This field is only present if an expiration date was specified when creating the entry.
`groupId`	ID of the Atlas project the user belongs to.
`links`	One or more links to sub-resources and/or related resources.
`roles`	Array of this user’s roles and the databases / collections on which the roles apply. A role allows the user to perform particular actions on the specified database. A role on the `admin` database can include privileges that apply to the other databases as well.
`roles.databaseName`	Database on which the user has the specified role. A role on the `admin` database can include privileges that apply to the other databases.
`roles.collectionName`	Collection on which the user has the specified role.
`roles.roleName`	Name of the role. The possible values are: `atlasAdmin` `readWriteAnyDatabase` `readAnyDatabase` `backup` `clusterMonitor` `dbAdmin` `dbAdminAnyDatabase` `enableSharding` This role is specific to MongoDB databases managed by Atlas. The role allows the user to enable sharding on a database and to shard a collection. `read` `readWrite` A name of a custom MongoDB role
`username`	Username for authenticating to MongoDB.

Example Request¶

Request¶

Important

You must modify the following code block with the appropriate credentials and project ID.

copy

curl -i -u "username:apiKey" --digest -H "Content-Type: application/json" -X PATCH "https://cloud.mongodb.com/api/atlas/v1.0/groups/5356823b3794dee37132bb7b/databaseUsers/admin/david" --data '
{
  "roles" : [ {
    "databaseName" : "service",
    "roleName" : "read"
  } ]
}'

Response¶

copy

HTTP/1.1 200 OK

{
  "databaseName" : "admin",
  "groupId" : "5356823b3794dee37132bb7b",
  "links" : [ ... ],
  "roles" : [ {
    "databaseName" : "service",
    "roleName" : "read"
  } ],
  "username" : "david"
}

← Create a Database User Delete a Database User →