The database's roles

GET

/provision/databases/{id}/roles

Paginated with limit (default 50, at most 500) and offset.

Capability: access:read (area resource, on the database).

Request

Path Params

Query Params

Responses

🟢200

application/json

The roles, each with how many keys it has out

Headers

Bodyapplication/json

🟠401KlockUnauthorized

🟠403CapabilityMissing

🟠404NotFound

Request Example

Shell

JavaScript

Java

Swift

curl --location 'https://api.prod-orm.io/provision/databases//roles?limit=&offset='

Response Example

200 - Example 1

{
    "roles": [
        {
            "id": "497f6eca-6276-4993-bfeb-53cbbbba6f08",
            "name": "string",
            "description": "string",
            "scope": {
                "ops": [
                    "read"
                ],
                "tables": [
                    "string"
                ],
                "columns": {
                    "property1": [
                        "string"
                    ],
                    "property2": [
                        "string"
                    ]
                }
            },
            "createdAt": "2019-08-24T14:15:22.123Z",
            "updatedAt": "2019-08-24T14:15:22.123Z",
            "holders": {
                "grants": 0,
                "keys": 0
            }
        }
    ],
    "page": {
        "limit": 0,
        "offset": 0,
        "returned": 0,
        "hasMore": true,
        "nextOffset": 0
    }
}

Modified at 2026-10-05 14:01:12

Run one described query under a passwordless credential

Define a role