[Qgis-developer] PostgreSQL table with column-specific insert permissions

[Pablo Fernández Moniz]

Hi!

Our team has recently found that whenever we define a PostgreSQL table with
column-specific insert permissions (see [1]), QGIS does not allow the
option to save a new feature, although it seems that is possible to update.

We checked that there are previous issues filed regarding this topic (
https://hub.qgis.org/issues/2468 and https://hub.qgis.org/issues/2689).

We would like to ask if there are any plans to support this PostgreSQL
behaviour in the future.

Thank you for your time,

Kind regards!!

Ps. I´m not sure if this is the right channel to communicate issues. If
there is another one better, please, tell me.

-----------------------------------------------------------------
[1] -- Permissions definition

CREATE schema network;
CREATE TABLE network.test
(
id bigint PRIMARY KEY,
geom geometry(LineString,32628),
protected_column boolean NOT NULL DEFAULT false
);

-- This GRANT INSERT is not supported
REVOKE ALL ON network.test FROM <user>;
GRANT SELECT ON network.test TO <user>;
GRANT INSERT (id, geom) ON network.test TO <user>;
-- There are no problems with this GRANT UPDATE
GRANT UPDATE (id, geom) ON network.test TO <user>;


-- This GRANT INSERT is supported
REVOKE ALL ON network.test FROM <user>;
GRANT SELECT ON network.test TO <user>;
GRANT INSERT ON network.test TO <user>;
-- There are no problems with this GRANT UPDATE
GRANT UPDATE (id, geom) ON network.test TO <user>;
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-developer/attachments/20160516/cc6e95e8/attachment.html>