Feature request #21016

PostgreSQL column permissions are ignored

Added by Nikolay Lebedev over 1 year ago. Updated over 1 year ago.

Status:Open
Priority:Normal
Assignee:-
Category:Data Provider/PostGIS
Pull Request or Patch supplied:No Resolution:
Easy fix?:No Copied to github as #:28835

Description

QGIS only allows you to create new features or modify them if you have full permissions on all columns of the table.

I.e. you have a table:

CREATE TABLE foo (
  id SERIAL PRIMARY KEY,
  restricted_column TEXT,
  geom GEOMETRY(Polygon, 4326)
);

Feature creation is enabled only when you have permissions on all columns:

GRANT INSERT ON foo TO qgis_user;

But not in this case:

REVOKE INSERT ON foo FROM qgis_user;
GRANT INSERT(id, geom) ON foo TO qgis_user;

Same goes to updating or deleting features.

History

#1 Updated by Jürgen Fischer over 1 year ago

  • Tracker changed from Bug report to Feature request

Also available in: Atom PDF