---
title: "Get a user"
---

> Documentation Index
> Fetch the complete documentation index at: https://docs.ezghcloud.com/llms.txt
> Use this file to discover all available pages before exploring further.

Path: Databases API

`GET /v1/organizations/{orgId}/projects/{projectId}/databases/{database}/users/{name}`

## Authentication

Requires one of the following:

- `apiKey`, http, header `Authorization`
- `oauth`, http, header `Authorization`
- `sessionCookie`, apiKey, in cookie

## Path parameters

- `GetDatabaseUser.path.orgId` (string, required) — UUID or prefixed ID (org_…)
- `GetDatabaseUser.path.projectId` (string, required) — UUID or prefixed ID (prj_…)
- `GetDatabaseUser.path.database` (string, required)
- `GetDatabaseUser.path.name` (string, required)

## Code samples

### cURL

```curl
curl --request GET \
  --url https://databases-api.ezghcloud.com/v1/organizations/string/projects/string/databases/string/users/string \
  --header 'Authorization: Bearer <token>'
```

### TypeScript

```typescript
const url = 'https://databases-api.ezghcloud.com/v1/organizations/string/projects/string/databases/string/users/string';
const options = {method: 'GET', headers: {Authorization: 'Bearer <token>'}};

fetch(url, options)
  .then(res => res.json())
  .then(json => console.log(json))
  .catch(err => console.error(err));
```

### Python

```python
import requests

url = "https://databases-api.ezghcloud.com/v1/organizations/string/projects/string/databases/string/users/string"

headers = {"Authorization": "Bearer <token>"}

response = requests.get(url, headers=headers)

print(response.text)
```

## Responses

### 200

The user.

#### Example

```json
{
  "createdAt": "2019-08-24T14:15:22Z",
  "database": "string",
  "failure": {
    "code": "string",
    "message": "string"
  },
  "logicalDatabase": "string",
  "managed": true,
  "name": "string",
  "observedAt": "2019-08-24T14:15:22Z",
  "preset": "readOnly",
  "secret": "string",
  "status": "creating"
}
```

- `GetDatabaseUser.response.200.createdAt` (string | null, required)
  - format `date-time`
- `GetDatabaseUser.response.200.database` (string, required) — The dbi_ it's in.
- `GetDatabaseUser.response.200.failure` (object | null, required) — Why a create failed, or the engine refused a user's drop (it stays, with secret null, until it's rotated). Null otherwise.
  - `GetDatabaseUser.response.200.failure.code` (string, required)
  - `GetDatabaseUser.response.200.failure.message` (string, required)
- `GetDatabaseUser.response.200.logicalDatabase` (string | null, required)
- `GetDatabaseUser.response.200.managed` (boolean, required) — Made through the API. False for one made by hand, seen in the database's latest report.
- `GetDatabaseUser.response.200.name` (string, required)
- `GetDatabaseUser.response.200.observedAt` (string | null, required) — When the database last reported what's in its engine; null before its first report.
  - format `date-time`
- `GetDatabaseUser.response.200.preset` (string | null, required)
  - one of `"readOnly"`, `"readWrite"`, `"owner"`, `null`
- `GetDatabaseUser.response.200.secret` (string | null, required) — The sec_ holding username, password, host, port, database, engine and uri. Null when unmanaged, or after a delete the engine refused.
- `GetDatabaseUser.response.200.status` (string | null, required) — Null when managed is false. missing: absent from the latest report, after a change made by hand; never repaired.
  - one of `"creating"`, `"available"`, `"modifying"`, `"rotating"`, `"deleting"`, `"missing"`, `"failed"`, `null`

### 400

invalid_request (with issues), invalid_cursor, or the endpoint's own 400 codes.

#### Example

```json
{
  "error": {
    "code": "string",
    "issues": [
      {
        "message": "string",
        "path": "string"
      }
    ],
    "message": "string",
    "quota": {
      "id": "string",
      "inFlight": 0,
      "kind": "allocation",
      "limit": 0,
      "periodStart": "2019-08-24T14:15:22Z",
      "region": "string",
      "resetsAt": "2019-08-24T14:15:22Z",
      "scope": "organization",
      "scopeResourceName": "string",
      "used": 0,
      "window": "string"
    }
  }
}
```

- `GetDatabaseUser.response.400.error` (object, required)
  - `GetDatabaseUser.response.400.error.code` (string, required)
    - maxLength 64; pattern `^[a-z][a-z0-9_]*$`
  - `GetDatabaseUser.response.400.error.message` (string, required)
    - maxLength 1024
  - `GetDatabaseUser.response.400.error.issues` (array<object>, optional) — invalid_request: one entry per problem, at a dotted path.
    - `GetDatabaseUser.response.400.error.issues.message` (string, required)
    - `GetDatabaseUser.response.400.error.issues.path` (string, required)
  - `GetDatabaseUser.response.400.error.quota` (object, optional) — quota_exceeded: the quota that refused the request. Never with Retry-After.
    - `GetDatabaseUser.response.400.error.quota.id` (string, required)
    - `GetDatabaseUser.response.400.error.quota.kind` (unknown, required)
      - one of `"allocation"`, `"rate"`, `"usage"`, `"concurrency"`
    - `GetDatabaseUser.response.400.error.quota.limit` (integer, required)
      - min 0
    - `GetDatabaseUser.response.400.error.quota.scope` (unknown, required)
      - one of `"organization"`, `"project"`, `"resource"`
    - `GetDatabaseUser.response.400.error.quota.inFlight` (integer, optional)
      - min 0
    - `GetDatabaseUser.response.400.error.quota.periodStart` (string, optional)
      - format `date-time`
    - `GetDatabaseUser.response.400.error.quota.region` (string, optional)
    - `GetDatabaseUser.response.400.error.quota.resetsAt` (string, optional)
      - format `date-time`
    - `GetDatabaseUser.response.400.error.quota.scopeResourceName` (string, optional)
    - `GetDatabaseUser.response.400.error.quota.used` (integer, optional)
      - min 0
    - `GetDatabaseUser.response.400.error.quota.window` (string, optional) — rate only: an ISO 8601 duration, PT1S to PT1H.

### 401

unauthenticated: no credential, or one that doesn't check out.

#### Example

```json
{
  "error": {
    "code": "string",
    "issues": [
      {
        "message": "string",
        "path": "string"
      }
    ],
    "message": "string",
    "quota": {
      "id": "string",
      "inFlight": 0,
      "kind": "allocation",
      "limit": 0,
      "periodStart": "2019-08-24T14:15:22Z",
      "region": "string",
      "resetsAt": "2019-08-24T14:15:22Z",
      "scope": "organization",
      "scopeResourceName": "string",
      "used": 0,
      "window": "string"
    }
  }
}
```

- `GetDatabaseUser.response.401.error` (object, required)
  - `GetDatabaseUser.response.401.error.code` (string, required)
    - maxLength 64; pattern `^[a-z][a-z0-9_]*$`
  - `GetDatabaseUser.response.401.error.message` (string, required)
    - maxLength 1024
  - `GetDatabaseUser.response.401.error.issues` (array<object>, optional) — invalid_request: one entry per problem, at a dotted path.
    - `GetDatabaseUser.response.401.error.issues.message` (string, required)
    - `GetDatabaseUser.response.401.error.issues.path` (string, required)
  - `GetDatabaseUser.response.401.error.quota` (object, optional) — quota_exceeded: the quota that refused the request. Never with Retry-After.
    - `GetDatabaseUser.response.401.error.quota.id` (string, required)
    - `GetDatabaseUser.response.401.error.quota.kind` (unknown, required)
      - one of `"allocation"`, `"rate"`, `"usage"`, `"concurrency"`
    - `GetDatabaseUser.response.401.error.quota.limit` (integer, required)
      - min 0
    - `GetDatabaseUser.response.401.error.quota.scope` (unknown, required)
      - one of `"organization"`, `"project"`, `"resource"`
    - `GetDatabaseUser.response.401.error.quota.inFlight` (integer, optional)
      - min 0
    - `GetDatabaseUser.response.401.error.quota.periodStart` (string, optional)
      - format `date-time`
    - `GetDatabaseUser.response.401.error.quota.region` (string, optional)
    - `GetDatabaseUser.response.401.error.quota.resetsAt` (string, optional)
      - format `date-time`
    - `GetDatabaseUser.response.401.error.quota.scopeResourceName` (string, optional)
    - `GetDatabaseUser.response.401.error.quota.used` (integer, optional)
      - min 0
    - `GetDatabaseUser.response.401.error.quota.window` (string, optional) — rate only: an ISO 8601 duration, PT1S to PT1H.

### 403

access_denied: the caller's policies don't allow the action; forbidden_origin: a cookie-authenticated write from an origin that isn't allowed; spend_limit_reached.

#### Example

```json
{
  "error": {
    "code": "string",
    "issues": [
      {
        "message": "string",
        "path": "string"
      }
    ],
    "message": "string",
    "quota": {
      "id": "string",
      "inFlight": 0,
      "kind": "allocation",
      "limit": 0,
      "periodStart": "2019-08-24T14:15:22Z",
      "region": "string",
      "resetsAt": "2019-08-24T14:15:22Z",
      "scope": "organization",
      "scopeResourceName": "string",
      "used": 0,
      "window": "string"
    }
  }
}
```

- `GetDatabaseUser.response.403.error` (object, required)
  - `GetDatabaseUser.response.403.error.code` (string, required)
    - maxLength 64; pattern `^[a-z][a-z0-9_]*$`
  - `GetDatabaseUser.response.403.error.message` (string, required)
    - maxLength 1024
  - `GetDatabaseUser.response.403.error.issues` (array<object>, optional) — invalid_request: one entry per problem, at a dotted path.
    - `GetDatabaseUser.response.403.error.issues.message` (string, required)
    - `GetDatabaseUser.response.403.error.issues.path` (string, required)
  - `GetDatabaseUser.response.403.error.quota` (object, optional) — quota_exceeded: the quota that refused the request. Never with Retry-After.
    - `GetDatabaseUser.response.403.error.quota.id` (string, required)
    - `GetDatabaseUser.response.403.error.quota.kind` (unknown, required)
      - one of `"allocation"`, `"rate"`, `"usage"`, `"concurrency"`
    - `GetDatabaseUser.response.403.error.quota.limit` (integer, required)
      - min 0
    - `GetDatabaseUser.response.403.error.quota.scope` (unknown, required)
      - one of `"organization"`, `"project"`, `"resource"`
    - `GetDatabaseUser.response.403.error.quota.inFlight` (integer, optional)
      - min 0
    - `GetDatabaseUser.response.403.error.quota.periodStart` (string, optional)
      - format `date-time`
    - `GetDatabaseUser.response.403.error.quota.region` (string, optional)
    - `GetDatabaseUser.response.403.error.quota.resetsAt` (string, optional)
      - format `date-time`
    - `GetDatabaseUser.response.403.error.quota.scopeResourceName` (string, optional)
    - `GetDatabaseUser.response.403.error.quota.used` (integer, optional)
      - min 0
    - `GetDatabaseUser.response.403.error.quota.window` (string, optional) — rate only: an ISO 8601 duration, PT1S to PT1H.

### 404

not_found: unknown, malformed, or in an organization the caller isn't in.

#### Example

```json
{
  "error": {
    "code": "string",
    "issues": [
      {
        "message": "string",
        "path": "string"
      }
    ],
    "message": "string",
    "quota": {
      "id": "string",
      "inFlight": 0,
      "kind": "allocation",
      "limit": 0,
      "periodStart": "2019-08-24T14:15:22Z",
      "region": "string",
      "resetsAt": "2019-08-24T14:15:22Z",
      "scope": "organization",
      "scopeResourceName": "string",
      "used": 0,
      "window": "string"
    }
  }
}
```

- `GetDatabaseUser.response.404.error` (object, required)
  - `GetDatabaseUser.response.404.error.code` (string, required)
    - maxLength 64; pattern `^[a-z][a-z0-9_]*$`
  - `GetDatabaseUser.response.404.error.message` (string, required)
    - maxLength 1024
  - `GetDatabaseUser.response.404.error.issues` (array<object>, optional) — invalid_request: one entry per problem, at a dotted path.
    - `GetDatabaseUser.response.404.error.issues.message` (string, required)
    - `GetDatabaseUser.response.404.error.issues.path` (string, required)
  - `GetDatabaseUser.response.404.error.quota` (object, optional) — quota_exceeded: the quota that refused the request. Never with Retry-After.
    - `GetDatabaseUser.response.404.error.quota.id` (string, required)
    - `GetDatabaseUser.response.404.error.quota.kind` (unknown, required)
      - one of `"allocation"`, `"rate"`, `"usage"`, `"concurrency"`
    - `GetDatabaseUser.response.404.error.quota.limit` (integer, required)
      - min 0
    - `GetDatabaseUser.response.404.error.quota.scope` (unknown, required)
      - one of `"organization"`, `"project"`, `"resource"`
    - `GetDatabaseUser.response.404.error.quota.inFlight` (integer, optional)
      - min 0
    - `GetDatabaseUser.response.404.error.quota.periodStart` (string, optional)
      - format `date-time`
    - `GetDatabaseUser.response.404.error.quota.region` (string, optional)
    - `GetDatabaseUser.response.404.error.quota.resetsAt` (string, optional)
      - format `date-time`
    - `GetDatabaseUser.response.404.error.quota.scopeResourceName` (string, optional)
    - `GetDatabaseUser.response.404.error.quota.used` (integer, optional)
      - min 0
    - `GetDatabaseUser.response.404.error.quota.window` (string, optional) — rate only: an ISO 8601 duration, PT1S to PT1H.

### 429

too_many_requests, with Retry-After; or quota_exceeded (a rate, usage or concurrency quota, with quota), never with Retry-After.

#### Example

```json
{
  "error": {
    "code": "string",
    "issues": [
      {
        "message": "string",
        "path": "string"
      }
    ],
    "message": "string",
    "quota": {
      "id": "string",
      "inFlight": 0,
      "kind": "allocation",
      "limit": 0,
      "periodStart": "2019-08-24T14:15:22Z",
      "region": "string",
      "resetsAt": "2019-08-24T14:15:22Z",
      "scope": "organization",
      "scopeResourceName": "string",
      "used": 0,
      "window": "string"
    }
  }
}
```

- `GetDatabaseUser.response.429.error` (object, required)
  - `GetDatabaseUser.response.429.error.code` (string, required)
    - maxLength 64; pattern `^[a-z][a-z0-9_]*$`
  - `GetDatabaseUser.response.429.error.message` (string, required)
    - maxLength 1024
  - `GetDatabaseUser.response.429.error.issues` (array<object>, optional) — invalid_request: one entry per problem, at a dotted path.
    - `GetDatabaseUser.response.429.error.issues.message` (string, required)
    - `GetDatabaseUser.response.429.error.issues.path` (string, required)
  - `GetDatabaseUser.response.429.error.quota` (object, optional) — quota_exceeded: the quota that refused the request. Never with Retry-After.
    - `GetDatabaseUser.response.429.error.quota.id` (string, required)
    - `GetDatabaseUser.response.429.error.quota.kind` (unknown, required)
      - one of `"allocation"`, `"rate"`, `"usage"`, `"concurrency"`
    - `GetDatabaseUser.response.429.error.quota.limit` (integer, required)
      - min 0
    - `GetDatabaseUser.response.429.error.quota.scope` (unknown, required)
      - one of `"organization"`, `"project"`, `"resource"`
    - `GetDatabaseUser.response.429.error.quota.inFlight` (integer, optional)
      - min 0
    - `GetDatabaseUser.response.429.error.quota.periodStart` (string, optional)
      - format `date-time`
    - `GetDatabaseUser.response.429.error.quota.region` (string, optional)
    - `GetDatabaseUser.response.429.error.quota.resetsAt` (string, optional)
      - format `date-time`
    - `GetDatabaseUser.response.429.error.quota.scopeResourceName` (string, optional)
    - `GetDatabaseUser.response.429.error.quota.used` (integer, optional)
      - min 0
    - `GetDatabaseUser.response.429.error.quota.window` (string, optional) — rate only: an ISO 8601 duration, PT1S to PT1H.

### 500

internal_error: a bug; the details are in the logs, under the request ID.

#### Example

```json
{
  "error": {
    "code": "string",
    "issues": [
      {
        "message": "string",
        "path": "string"
      }
    ],
    "message": "string",
    "quota": {
      "id": "string",
      "inFlight": 0,
      "kind": "allocation",
      "limit": 0,
      "periodStart": "2019-08-24T14:15:22Z",
      "region": "string",
      "resetsAt": "2019-08-24T14:15:22Z",
      "scope": "organization",
      "scopeResourceName": "string",
      "used": 0,
      "window": "string"
    }
  }
}
```

- `GetDatabaseUser.response.500.error` (object, required)
  - `GetDatabaseUser.response.500.error.code` (string, required)
    - maxLength 64; pattern `^[a-z][a-z0-9_]*$`
  - `GetDatabaseUser.response.500.error.message` (string, required)
    - maxLength 1024
  - `GetDatabaseUser.response.500.error.issues` (array<object>, optional) — invalid_request: one entry per problem, at a dotted path.
    - `GetDatabaseUser.response.500.error.issues.message` (string, required)
    - `GetDatabaseUser.response.500.error.issues.path` (string, required)
  - `GetDatabaseUser.response.500.error.quota` (object, optional) — quota_exceeded: the quota that refused the request. Never with Retry-After.
    - `GetDatabaseUser.response.500.error.quota.id` (string, required)
    - `GetDatabaseUser.response.500.error.quota.kind` (unknown, required)
      - one of `"allocation"`, `"rate"`, `"usage"`, `"concurrency"`
    - `GetDatabaseUser.response.500.error.quota.limit` (integer, required)
      - min 0
    - `GetDatabaseUser.response.500.error.quota.scope` (unknown, required)
      - one of `"organization"`, `"project"`, `"resource"`
    - `GetDatabaseUser.response.500.error.quota.inFlight` (integer, optional)
      - min 0
    - `GetDatabaseUser.response.500.error.quota.periodStart` (string, optional)
      - format `date-time`
    - `GetDatabaseUser.response.500.error.quota.region` (string, optional)
    - `GetDatabaseUser.response.500.error.quota.resetsAt` (string, optional)
      - format `date-time`
    - `GetDatabaseUser.response.500.error.quota.scopeResourceName` (string, optional)
    - `GetDatabaseUser.response.500.error.quota.used` (integer, optional)
      - min 0
    - `GetDatabaseUser.response.500.error.quota.window` (string, optional) — rate only: an ISO 8601 duration, PT1S to PT1H.

### 503

unavailable: a dependency the request needs is down. Retry after Retry-After.

#### Example

```json
{
  "error": {
    "code": "string",
    "issues": [
      {
        "message": "string",
        "path": "string"
      }
    ],
    "message": "string",
    "quota": {
      "id": "string",
      "inFlight": 0,
      "kind": "allocation",
      "limit": 0,
      "periodStart": "2019-08-24T14:15:22Z",
      "region": "string",
      "resetsAt": "2019-08-24T14:15:22Z",
      "scope": "organization",
      "scopeResourceName": "string",
      "used": 0,
      "window": "string"
    }
  }
}
```

- `GetDatabaseUser.response.503.error` (object, required)
  - `GetDatabaseUser.response.503.error.code` (string, required)
    - maxLength 64; pattern `^[a-z][a-z0-9_]*$`
  - `GetDatabaseUser.response.503.error.message` (string, required)
    - maxLength 1024
  - `GetDatabaseUser.response.503.error.issues` (array<object>, optional) — invalid_request: one entry per problem, at a dotted path.
    - `GetDatabaseUser.response.503.error.issues.message` (string, required)
    - `GetDatabaseUser.response.503.error.issues.path` (string, required)
  - `GetDatabaseUser.response.503.error.quota` (object, optional) — quota_exceeded: the quota that refused the request. Never with Retry-After.
    - `GetDatabaseUser.response.503.error.quota.id` (string, required)
    - `GetDatabaseUser.response.503.error.quota.kind` (unknown, required)
      - one of `"allocation"`, `"rate"`, `"usage"`, `"concurrency"`
    - `GetDatabaseUser.response.503.error.quota.limit` (integer, required)
      - min 0
    - `GetDatabaseUser.response.503.error.quota.scope` (unknown, required)
      - one of `"organization"`, `"project"`, `"resource"`
    - `GetDatabaseUser.response.503.error.quota.inFlight` (integer, optional)
      - min 0
    - `GetDatabaseUser.response.503.error.quota.periodStart` (string, optional)
      - format `date-time`
    - `GetDatabaseUser.response.503.error.quota.region` (string, optional)
    - `GetDatabaseUser.response.503.error.quota.resetsAt` (string, optional)
      - format `date-time`
    - `GetDatabaseUser.response.503.error.quota.scopeResourceName` (string, optional)
    - `GetDatabaseUser.response.503.error.quota.used` (integer, optional)
      - min 0
    - `GetDatabaseUser.response.503.error.quota.window` (string, optional) — rate only: an ISO 8601 duration, PT1S to PT1H.


Source: https://docs.ezghcloud.com/databases-api/GetDatabaseUser/index.md
