Re: Execute function without execute privilege

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: "Walker, Jed S" <Jed_Walker(at)cable(dot)comcast(dot)com>
Cc: 'Tom Lane' <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "'pgsql-novice(at)postgresql(dot)org'" <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Execute function without execute privilege
Date: 2005-05-06 16:02:28
Message-ID: 20050506160228.GA12218@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

On Fri, May 06, 2005 at 08:45:41 -0600,
"Walker, Jed S" <Jed_Walker(at)cable(dot)comcast(dot)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.

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Keith Worthington 2005-05-06 19:45:02 returned row number
Previous Message Brad Nicholson 2005-05-06 15:59:16 Re: connect from perl: error in Carp.pm