[postgis-users] Securing postgis

[Mark Cave-Ayland]

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