This section describes the operations that are supported for managing database users.
In this section, "user has access to a database" means that the user has full create, read, update, and delete access to the given database. In other words, on a cloud database instance, a user named USER and a database named DATABASE exist, and within MySQL, a GRANT ALL ON DATABASE.* TO USER has been issued on the instance.
| Verb | URI | Description |
|---|---|---|
| POST | /instances/{instanceId}/users | Creates a user for the specified database instance. |
| GET | /instances/{instanceId}/users | Lists the users in the specified database instance. |
| PUT | /instances/{instanceId}/users | Changes the MySQL password of one or more users. |
| GET | /instances/{instanceId}/users/{name} | Lists the specified user's name and a list of databases that the user can access. |
| DELETE | /instances/{instanceId}/users/{name} | Deletes the user identified by {name} for the specified database instance. |
| GET | /instances/{instanceId}/users/{name}/databases | Shows a list of all databases a user has access to. |
| PUT | /instances/{instanceId}/users/{name}/databases | Grants access for the specified user to one or more databases for the specified instance. |
| DELETE | /instances/{instanceId}/users/{name}/databases/{databaseName} | Removes access to the specified database for the specified user. |
