Temporary database users (dbusers)
Overview
Manages temporary domain database user accounts.
Information for database connection is obtained from the parameters of the corresponding role, excluding 'dc', whose database access is prohibited.
Requests
| HTTP verb | Endpoint | Description |
|---|---|---|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Getting the list of databases
Returns a list of the domain’s databases. Each of the elements is a database key string used in endpoint queries to manage temporary database users.
Creating a new temporary database user
Creates a role and a temporary user account with a validity restriction until the end of the current day in the time zone of the database server. Returns the account password in plaintext.
An object is passed as the content of the request, which may contain an access property that defines the access level for the user (value options: read, write).
The access level to be set cannot be higher than the allowed access level for the domain (a property of the current domain set from the parent domain).
Getting the list of temporary database users
Returns a list of actual temporary user accounts of the specified database. It does not return passwords.
Response
HTTP/1.1 200 OK
Content-Type: application/json; charset=utf-8
[
{
"host": "192.168.0.32",
"port": 5432,
"login": "tmp_rRpyH0hgS",
"database": "era_dummy_central_common",
"validuntil": "2019-09-23 00:00:00+03"
},
{
"host": "192.168.0.32",
"port": 5432,
"login": "tmp_wyPHG0NN1",
"database": "era_dummy_central_common",
"validuntil": "2019-09-21 00:00:00+03"
}
]See also
-
API management of temporary database users with expired validity period (rest/v1/iam/dbusers_by_expiration)