---
title: "[BETA] List DBaaS ClickHouse roles"
method: GET
path: "/dbaas-clickhouse/{service-name}/role"
tags: ["dbaas"]
---

# \[BETA\] List DBaaS ClickHouse roles

`GET /dbaas-clickhouse/{service-name}/role`

## Request

- Base URL: `https://api-ch-gva-2.exoscale.com/v2`
- URL: `https://api-ch-gva-2.exoscale.com/v2/dbaas-clickhouse/{service-name}/role`
- Auth: none declared
- TypeScript: <https://skmtc.dev/exoscale/apis/exoscale-api/docs/dbaas-clickhouse/:service-name/role/get.ts> (a function with typed inputs; its response is checked against the schema)

## Path parameters

- `service-name` string, required

## Response `200`

200

- DbaasClickhouseRoles
  - `roles` DbaasClickhouseRole[]
    - `name` string, required
    - `uuid` string
    - `privileges` DbaasClickhouseRolePrivilege[]
      - `name` string, required
      - `database` string: Database
      - `table` string: Table
      - `grant-option` boolean
      - `column` string: Column
      - `is-partial-revoke` boolean
    - `granted-roles` DbaasClickhouseGrantedRole[]
      - `name` string, required: Granted role name
      - `uuid` string
      - `is-default` boolean
      - `with-admin-option` boolean

---

[API](https://skmtc.dev/exoscale/apis/exoscale-api.md) - [All operations](https://skmtc.dev/exoscale/apis/exoscale-api/llms.txt) - [OpenAPI document](https://skmtc.dev/exoscale/apis/exoscale-api/revisions/63da6f74c845?raw)