Created attachment 57709 [details]
test case - client side

Regression wrt to 3.5.0.

When PostgreSQL user A is member of group B, and group B has privileges on table T, LibreOffice 3.5.1 ignores these privileges. As a consequence, for example it keeps the user connected as PostgreSQL-user A from editing data in table T, although group B (and thus indirectly A) has the privilege to do it.

psql -Upostgres:
# CREATE ROLE master WITH LOGIN;
# CREATE ROLE tst WITH LOGIN PASSWORD 'foo' IN ROLE editors;
Load attached database dump in a PostgreSQL server (version 8.4 or later).


psql -Ujohn
> INSERT INTO dbtable VALUES (5, 4, 2, TRUE);
INSERT 0 1
(that is, success)
> UPDATE dbtable SET field4=FALSE WHERE field1=5;
UPDATE 1
(again, success)


Open attached .odb file. Correct hostname and/or dbname in menu edit / database / properties. Open form "dbtable". Cannot edit/insert data: all controls greyed out or locked.

With LibreOffice 3.5.0, can edit/insert data.