Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: stored function and grant execute
- From: Michael Fuhr <mike(at)fuhr(dot)org>
- To: "P.M" <pmdanger(at)yahoo(dot)com>
- Cc: PostgreSQL General <pgsql-general(at)postgresql(dot)org>
- Subject: Re: stored function and grant execute
- Date: Sun, 28 May 2006 07:32:01 -0600
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
- References:
- stored function and grant execute
- From: P.M
- stored function and grant execute
- Prev by Date: Best open source tool for database design / ERDs?
- Next by Date: Re: postgres 7 and eastern language
- Previous by thread: Re: stored function and grant execute
- Next by thread: postgres 7 and eastern language
- Indexes: