You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Author Name: pinux - (pinux -)
Original Redmine Issue: 2468
Redmine category:data_provider
Assignee: nobody -
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(mycolumn) ON mytable TO user;
GRANT UPDATE(mycolumn) ON mytable TO user;
It is not possible to edit the column mycolumn in qgis.
The text was updated successfully, but these errors were encountered:
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.
Author Name: pinux - (pinux -)
Original Redmine Issue: 2468
Redmine category:data_provider
Assignee: nobody -
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(mycolumn) ON mytable TO user;
GRANT UPDATE(mycolumn) ON mytable TO user;
It is not possible to edit the column mycolumn in qgis.
The text was updated successfully, but these errors were encountered: