[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