---
title: "List all roles"
method: GET
path: "/project/{project}/service/{service_name}/clickhouse/role"
tags: ["Service:_ClickHouse"]
---

# List all roles

`GET /project/{project}/service/{service_name}/clickhouse/role`

Lists all roles in ClickHouse.

## Path parameters

- `project` string, required
- `service_name` string, required

## Response `200`

Response

- ServiceClickHouseRoleListResponse — ServiceClickHouseRoleListResponse
  - `errors` object[] — List of errors occurred during request processing
    - `message` string, required — Printable error message
    - `more_info` string — URL to the documentation of the error
    - `status` integer, required — HTTP error status code
  - `message` string — Printable result of the request
  - `roles` object[], required — List of roles
    - `name` string, required — Role name
    - `privileges` object[], required — Role privileges
      - `access_type` string, required — Access type
      - `column` string, required — Column name
      - `database` string, required — Database name
      - `grant_option` boolean, required — With grant option
      - `is_partial_revoke` boolean, required — Is partial revoke
      - `table` string, required — Table name
    - `roles` object[], required — Role roles
      - `is_default` boolean, required — Is default
      - `name` string, required — Role name
      - `uuid` string, required — Role uuid
      - `with_admin_option` boolean, required — With admin option
    - `uuid` string, required — Role uuid

---

[API](https://skmtc.net/aiven/apis/aiven-api-documentation.md) · [All operations](https://skmtc.net/aiven/apis/aiven-api-documentation/llms.txt) · [OpenAPI document](https://skmtc-service-staging.skmtc.workers.dev/v1/apis/aiven/aiven-api-documentation/versions/ecaeabf1da31/schema)