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

# List all users

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

Lists all users in ClickHouse.

## Path parameters

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

## Response `200`

Response

- ServiceClickHouseUserListResponse — ServiceClickHouseUserListResponse
  - `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
  - `users` object[], required — List of users
    - `name` string, required — User name
    - `password` string — User password
    - `privileges` object[], required — User 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
    - `required` boolean, required — Required user
    - `roles` object[], required — User 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 — User 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)