[postgis-devel] [PostGIS] #1260: Topology: Support security access to tables

PostGIS trac at osgeo.org
Mon Oct 31 04:21:08 PDT 2011


#1260: Topology: Support security access to tables
-------------------------+--------------------------------------------------
 Reporter:  aperi2007    |       Owner:  strk          
     Type:  enhancement  |      Status:  new           
 Priority:  medium       |   Milestone:  PostGIS Future
Component:  topology     |     Version:  trunk         
 Keywords:               |  
-------------------------+--------------------------------------------------
 Actually an user could access directly to the tables and a wrongly query
 could destroy the topology.
 As esample an user could think to execute this query:

 delete * from edge_data where left_face=right_face to remove dangles
 edges.

 But this query could destroy the topology because don't update the node
 table.

 Instead the right query is this:

 delete ST_RemEdgeModFace(idedge) from edge_data where
 left_face=right_face;

 this correctly update also the node table.

 To avoid this , a good choice should be deny the access
 (write/update/delete) directly to the tables using and allow the access
 directly only to a user with a "topology_master" specific grant.
 And leave to all the user only the "read" grant to the tables.

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/1260>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.


More information about the postgis-devel mailing list