questdb / questdb/questdb

Ability to add users and control permissions per table.

Open
#996 2 comments 3 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

Core New feature
Dominant language
Java
Stars
17.3k
Forks
1.6k
Avg merge
5d 10h
Merged PRs (30d)
28

Description

Is your feature request related to a problem? Please describe.
If you have an organization, where you want different people (or teams) to be able to view different tables. In addition you want want to allow those who view a table, ability to edit (add / remove) and drop table altogether. It's unclear to be how this may be achieved currently with QDB.

Describe the solution you'd like
It would be cool if users can be created - thus allowing access to the DB and for each user to be able to control their view / edit / delete permissions. If this can be done through the UI for an admin user - even better.

Describe alternatives you've considered
@ideoma suggested changing FS permissions on directory, so this could be definitely one approach I guess. Alternatively I was thinking that exposing the data via REST (or another layer) and handling permissions there is another way of acheving similar results. Downside being that other users don't know / interact directly with the backend.

Additional context
None.

Contributor guide

Open the contributing guide

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Research direction

No files, tests, or entry points are named. Start by clarifying QDB's current access model and whether the scope includes user creation, per-table permissions, and an admin UI or REST layer; done requires an agreed design and tests covering the selected permission boundaries.

Written by the indexing model from the issue text.

Assessment

Tech stack
java
Domain
authorization, database
Issue type
Feature
Difficulty
5/5
Estimated time
Over a week
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
20/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.