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
data.
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.
ATB,
Mark.
--
Mark Cave-Ayland - Senior Technical Architect
PostgreSQL - PostGIS
Sirius Corporation plc - control through freedom
http://www.siriusit.co.uk
t: +44 870 608 0063
Sirius Labs: http://www.siriusit.co.uk/labs
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
