[postgis-users] Securing postgis
mark.cave-ayland at siriusit.co.uk
Wed Mar 2 07:55:57 PST 2011
On 02/03/11 15:17, Karl O. Pinc wrote:
> Yes, I've been thinking more about this and have come to
> the same conclusion you have. The right way to go is
> to put triggers on geometry_columns that check permissions
> against what's granted on the column holding the geometry
> Any clue if this would be something I could send in
> as a patch to the postgis project?
Probably not, as I believe Paul is planning to switch the binary
representation of the geometry type in 2.0 which would then enable us to
make geometry_columns a view just like geography_columns.
However, it would probably be of interest to enough people to add it
somewhere to the user part of the wiki.
Mark Cave-Ayland - Senior Technical Architect
PostgreSQL - PostGIS
Sirius Corporation plc - control through freedom
t: +44 870 608 0063
Sirius Labs: http://www.siriusit.co.uk/labs
More information about the postgis-users