Re: stored function and grant execute

On Sun, May 28, 2006 at 02:11:59AM -0700, P.M wrote:
> I'm developping a web application which use PostgreSQL as database.
> I'm quite surprise to see that grant execute does not exist for
> PostgreSQL v7.x, but only in v8.x

What version of 7.x are you running?  The EXECUTE privilege was
added in 7.3, which was released over three years ago.  Older
versions are no longer supported.

> So how can i grant such right (execute) to my user in v7.x ?
> because function were already existing in v7.x

I don't recall what pre-7.3 behavior is, but in 7.3 and later
functions' default privileges allow EXECUTE for public (everybody).
If you're running a version that doesn't have EXECUTE then you're
badly in need of an upgrade.

--
Michael Fuhr