Chelabase
ManagementMembers

Create your personal login on a database

PUT
/v1/databases/{id}/personal-login

Your own Postgres login for this database, for Developers and above there (tenant admins included). Its password is generated and answered this once, with Cache-Control: no-store; only a SCRAM verifier is stored. It is valid for 90 days (a password reset renews it) and works on every branch where you qualify, acting only as the roles you hold at Developer or above. A revoked or expired login of yours on the database is replaced.

Authorization

bearer
AuthorizationBearer <token>

In: header

Path Parameters

id*string

Database id

Formatuuid

Request Body

application/json

TypeScript Definitions

Use the request body type in TypeScript.

name*string

The login's Postgres role name: ^[a-z_][a-z0-9_]{0,62}$, not reserved, and not taken by any role on any branch of the database nor by another login of it.

Response Body

application/json

application/json

application/json

application/json

application/json

application/json

application/json

application/json

application/json

application/json

curl -X PUT "https://example.com/v1/databases/497f6eca-6276-4993-bfeb-53cbbbba6f08/personal-login" \  -H "Content-Type: application/json" \  -d '{    "name": "string"  }'
{  "connection_string": "string",  "login": {    "created_at": "2019-08-24T14:15:22Z",    "database_id": "91088904-0b92-46ad-9240-e1afa0da22df",    "database_name": "string",    "member_id": "435a4844-006a-4cfc-a644-e8eb2dd2ca43",    "project_id": "405d8375-3514-403b-8c43-83ae74cfe0e9",    "revoked_at": "2019-08-24T14:15:22Z",    "revoked_reason": "access_lost",    "role_name": "string",    "status": "active",    "valid_until": "2019-08-24T14:15:22Z"  },  "password": "string",  "ready_on_main": true}

Read the tenant's access log GET

Every access change (members, grants, overrides, invites, open sign-up, the tenant's name), newest first. The log can't be changed.

Reset your personal login's password POST

A new generated password, answered this once with `Cache-Control: no-store`; the old one is refused at once. It also renews the login for 90 days (an expired login comes back this way). A revoked login can't be reset: make a new one.