Fix readonly user permissions in clickhouse cluster
Open
@hellais is already working on this.
Since May 20, 2025.
chore
funder/otffoss2025
- Dominant language
- HCL
- Stars
- 4
- Forks
- 15
- Avg merge
- 1h 50m
- Merged PRs (30d)
- 4
Description
Currently, due to the fact we would like to set things like query priority or maximum query time in the application which is not allowed in readonly mode, we had to use the write user in many places where we would rather not.
We should create a new readonly user that has these permissions and update the following clickhouse URLs to one which has also edit settings permissions: https://clickhouse.com/docs/operations/settings/permissions-for-queries.
The places to update are:
- grafana clickhouse data source
- ooni-api in backend-fsn
Contributor guide
No contributing guide indexed for this repository
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Assessment
This issue has not been assessed yet.