Re: function permissions question

From: "Greg Steffensen" <greg(dot)steffensen(at)gmail(dot)com>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: function permissions question
Date: 2007-12-09 06:36:46
Message-ID: 438a23610712082236q16b7ebefp24e9c6ab28e53728@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Excellent, thanks for the quick response.

Greg

On Dec 9, 2007 1:18 AM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> "Greg Steffensen" <greg(dot)steffensen(at)gmail(dot)com> writes:
> > Hey, I'm slightly confused about how the permission checking is done
> > when executing functions. Basically, users that I've never granted
> > execution permissions to are able to execute functions.
>
> You didn't read the part of the GRANT man page that says that functions
> have execute permissions granted to PUBLIC by default.
>
> You can revoke that if you don't like it.
>
> regards, tom lane
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Alain Roger 2007-12-09 15:41:01 sequence
Previous Message Tom Lane 2007-12-09 06:18:23 Re: function permissions question