Re: Execute function without execute privilege - Mailing list pgsql-novice

From Bruno Wolff III
Subject Re: Execute function without execute privilege
Date
Msg-id 20050506160228.GA12218@wolff.to
Whole thread Raw
In response to Re: Execute function without execute privilege  ("Walker, Jed S" <Jed_Walker@cable.comcast.com>)
List pgsql-novice
On Fri, May 06, 2005 at 08:45:41 -0600,
  "Walker, Jed S" <Jed_Walker@cable.comcast.com> wrote:
> Do you mean that when I create a function an implicit "grant execute on
> function" is done? If so, we would have to do a revoke with each grant. Or,
> do you mean there is a public grant to "execute any function" that I can
> just remove when I create the database (and if so, how?)

When a function is created it is created with "public" having execute access
to it. You will need to do a revoke after each function creation.

pgsql-novice by date:

Previous
From: "Walker, Jed S"
Date:
Subject: Re: Execute function without execute privilege
Next
From: Tom Lane
Date:
Subject: Re: Execute function without execute privilege