Temporary database users with expired validity period (dbusers_by_expiration)

Overview

Manages temporary expired domain database user accounts.

Requests

HTTP verb Endpoint Description

GET

/rest/v1/iam/dbusers_by_expiration/<DB>

Getting the list of temporary database users

DELETE

/rest/v1/iam/dbusers_by_expiration/<DB>

Deleting temporary database users with expired validity time

To obtain a list of databases, you should query on the endpoint /rest/v1/iam/dbusers.


Getting the list of temporary database users

Returns a list of expired temporary user accounts of the specified database. It does not return passwords.

Request

Request example
GET /rest/v1/iam/dbusers_by_expiration/dummy HTTP/1.1

Response

Response example
HTTP/1.1 200 OK
Content-Type: application/json; charset=utf-8

[
  {
    "host": "192.168.0.32",
    "port": 5432,
    "login": "tmp_wX9a4eFPg",
    "database": "era_dummy_central_common",
    "validuntil": "2019-05-12 00:00:00+03"
  },
  {
    "host": "192.168.0.32",
    "port": 5432,
    "login": "tmp_rtm39E0RR",
    "database": "era_dummy_central_common",
    "validuntil": "2019-05-13 00:00:00+03"
  }
]

Deleting temporary database users with expired validity time

Request

Request example
DELETE /rest/v1/iam/dbusers_by_expiration/dummy HTTP/1.1

Response

Response example
HTTP/1.1 204 No Content

See also