| From: | Michael Fuhr <mike(at)fuhr(dot)org> |
|---|---|
| To: | "P(dot)M" <pmdanger(at)yahoo(dot)com> |
| Cc: | PostgreSQL General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: stored function and grant execute |
| Date: | 2006-05-28 13:32:01 |
| Message-ID: | 20060528133201.GA68743@winnie.fuhr.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jorge Godoy | 2006-05-28 13:41:23 | Re: postgres 7 and eastern language |
| Previous Message | dananrg | 2006-05-28 12:19:04 | Best open source tool for database design / ERDs? |