We've added two new API endpoints to help you manage Postgres database roles.
Reassign role objects
When you need to transfer ownership of database objects from one role to another, you can now do it via the API:
/v1/organizations/{organization}/databases/{database}/branches/{branch}/roles/{id}/reassign— Reassign all objects owned by one role to another role
Reset role password
Need to reset a role's password? There's now an endpoint for that:
/v1/organizations/{organization}/databases/{database}/branches/{branch}/roles/{id}/reset— Reset a role's password
This generates a new password for the role, which you'll get back in the response.
Read the roles API documentation for more details on managing Postgres roles.