[QGIS-trac] Re: [Quantum GIS] #2468: Support for Column Permissions in PostgreSQL 8.4

[Quantum GIS]

#2468: Support for Column Permissions in PostgreSQL 8.4
-----------------------------------------------------+----------------------
        Reporter:  pinux                             |         Owner:  nobody                            
            Type:  enhancement                       |        Status:  closed                            
        Priority:  major: does not work as expected  |     Milestone:  Version 1.5.0                     
       Component:  Data Provider                     |       Version:  HEAD                              
      Resolution:  fixed                             |      Keywords:  postgis postgres column permission
Platform_version:                                    |      Platform:  All                               
        Must_fix:  No                                |   Status_info:  0                                 
-----------------------------------------------------+----------------------
Changes (by jef):

  * status:  new => closed
  * resolution:  => fixed

Comment:

 fixed in r13014.

 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.

-- 
Ticket URL: <https://trac.osgeo.org/qgis/ticket/2468#comment:2>
Quantum GIS <http://qgis.org>
Quantum GIS is an Open Source GIS viewer/editor supporting OGR, PostGIS, and GRASS formats