Bug 47937 - EDITING UI locks tables read-only when write privilege over only *some* columns
Summary: EDITING UI locks tables read-only when write privilege over only *some* columns
Status: RESOLVED FIXED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
3.5 Daily
Hardware: Other All
: medium normal
Assignee: Lionel Elie Mamane
URL:
Whiteboard: target:3.6.0 target:3.5.3
Keywords:
Depends on:
Blocks:
 
Reported: 2012-03-27 01:48 UTC by Lionel Elie Mamane
Modified: 2012-03-28 08:17 UTC (History)
0 users

See Also:
Crash report or crash signature:

Attachments
copy column privileges into table privileges (5.77 KB, patch)
2012-03-27 01:50 UTC, Lionel Elie Mamane 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Lionel Elie Mamane 2012-03-27 01:48:30 UTC 
Reproduced with PostgreSQL-SDBC; predicted to also be the case with PostgreSQL-JDBC and several other multi-user DBMS:


CREATE TABLE foo (col1, col2, col3)
-- either col1 allowed NULL or col1 has a default value
GRANT INSERT, UPDATE (col2, col3) ON foo TO usr

Connect to database as user "usr" from LibreOffice. One cannot insert values in table foo, nor edit values in columns col2 or col3: the UI locks them.
Comment 1 Lionel Elie Mamane 2012-03-27 01:50:30 UTC 
Created attachment 59108 [details]
copy column privileges into table privileges
Comment 2 Not Assigned 2012-03-27 01:55:39 UTC 
Lionel Elie Mamane committed a patch related to this issue.
It has been pushed to "master":

http://cgit.freedesktop.org/libreoffice/core/commit/?id=077e711b5f5f19fceed44e2d992bf5c027e75ab6

fdo#47937: copy column privileges into table privileges
Comment 3 Not Assigned 2012-03-28 08:16:56 UTC 
Lionel Elie Mamane committed a patch related to this issue.
It has been pushed to "libreoffice-3-5":

http://cgit.freedesktop.org/libreoffice/core/commit/?id=01790af488fad56f0600fc755ee9e976e3aa3a5f&g=libreoffice-3-5

fdo#47937: copy column privileges into table privileges


It will be available in LibreOffice 3.5.3.