Feature request #2468

Support for Column Permissions in PostgreSQL 8.4

Added by pinux - over 10 years ago. Updated over 10 years ago.

Status:Closed
Priority:Low
Assignee:nobody -
Category:Data Provider
Pull Request or Patch supplied: Resolution:fixed
Easy fix?:No Copied to github as #:12528

Description

Column Permission in PostgreSQL 8.4 is not supported in Qgis. When I grant insert or update on a specific column, like this:
GRANT INSERT ON mytable TO user;
GRANT UPDATE ON mytable TO user;

It is not possible to edit the column mycolumn in qgis.

History

#1 Updated by Jürgen Fischer over 10 years ago

  • Resolution set to fixed
  • Status changed from Open to Closed

fixed in b0a9d994 (SVN r13015).

the postgres provider now checks if the user has update privilege on the geometry column when checking if geometry changes should be enabled and update privileges on any/at least one attribute column to enable attribute changes. Enabling addition of new features still requires table insert privilege (ie. insert privilege on all columns).

Note: that way edits of readonly attribute columns are not forbidden, but will cause the commit to fail. To prevent that either don't change those attributes in the first place or set the read-only attributes 'Immutable' or 'Hidden' in the attribute tab of vector layer properties, so that the are not changeable in the UI - although plugins could still change readonly attributes.

Also available in: Atom PDF