dbeaver / dbeaver/dbeaver

Allow customizing Data Filters for tables with permissions on columns

Open
#34,223 3 comments 0 reactions 0 assignees View on GitHub
x:postgresql xf:data xf:metadata
Dominant language
Java
Stars
51.8k
Forks
4.4k
Avg merge
3d 8h
Merged PRs (30d)
188

Description

**Is your feature request related to a problem? Please describe.**
In postgres - you can grant `SELECT` on specific columns of a table.
Let's assume I have a table called `"Users"` and I gave user `testuser` `SELECT` permissions only on some of its columns.
While connected with user `testuser`:
When you try to view the table's properties - it works fine as expected.
When you try to view it's data - it fails due to the permission error because it tries to do a `select *` - also expected.
If you try to customize the `Data Filters` - the modal is empty and it's not possible to select specific columns
![image](https://github.com/dbeaver/dbeaver/assets/18515297/c18a9d8d-91bc-4f3f-bc88-b7e77b1bc4aa)

**Describe the solution you'd like**
Assuming `Data Filters` also affect the query being run (i.e specific columns instead of `*`) - the modal should rely on the metadata of the table for displaying the columns, rather than relying on the Data tab to actually load data.
If it does not - it should...
The goal is to continue working seamlessly with the Database Navigator and for example being able to click on the arrow of a FK value to load the parent table (i.e in table `Users`) and still be able to see the "allowed" columns without having to turn to raw SQL.

**Describe alternatives you've considered**
It's still possible to query the table using raw SQL in SQL Editor

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.