[postgis-devel] estimated_extent & pg_statistic

Mark Cave-Ayland m.cave-ayland at webbased.co.uk
Wed Feb 22 06:39:02 PST 2006


 

> -----Original Message-----
> From: postgis-devel-bounces at postgis.refractions.net 
> [mailto:postgis-devel-bounces at postgis.refractions.net] On 
> Behalf Of strk at refractions.net
> Sent: 22 February 2006 14:24
> To: postgis-devel at postgis.refractions.net
> Subject: Re: [postgis-devel] estimated_extent & pg_statistic
> 
> estimated_extent *needs* to know about minimum and maximum 
> salary :) Does anybody know if it possilble to have functions 
> run in 'setuid' mode rather then with permissions derived by 
> caller user ?
> 
> --strk;


Hi strk,

Yes you can do this by marking the function as SECURITY DEFINER. It might
also be an idea to mark the AddGeometryColumn(), DropGeometryColumn() and
find_srid() functions in this way so you can revoke user permissions from
the geometry_columns table, yet they can still make use of these functions.


Kind regards,

Mark.

------------------------
WebBased Ltd
17 Research Way
Plymouth
PL6 8BT

T: +44 (0)1752 797131
F: +44 (0)1752 791023

http://www.webbased.co.uk   
http://www.infomapper.com
http://www.swtc.co.uk  

This email and any attachments are confidential to the intended recipient
and may also be privileged. If you are not the intended recipient please
delete it from your system and notify the sender. You should not copy it or
use it for any purpose nor disclose or distribute its contents to any other
person.





More information about the postgis-devel mailing list