Skip to main content
Overview of ClickHouse users, roles, and their permissions. Users managed by ClickHouse (*-internal, default) and SQL console users (sql-console*) are not documented here… they are provisioned automatically. Workspace users (ws_*) are also excluded, cuz we create them ourselves.

Users

UserPurposeRoles / Grants
grafanaGrafana dashboardsgrafana_readonly, readonly_role
apiv2API v2 serviceinsertonly_role, readonly_role
sentinelSentinel servicedirect grants (see script)
vectorRuntime logsINSERT on runtime_logs_raw_v1
githubGitHub integrationsreadonly_role
vercel_dashboardVercel dashboardreadonly_role
unkey_adminAdmin accessall roles

Roles

RolePurpose
readonly_roleSELECT on default.*
insertonly_roleINSERT on default.*
grafana_readonlyColumn-level SELECT on system.* tables