QGIS » QGIS Application

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.