Re: function permissions question

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

"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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Greg Steffensen 2007-12-09 06:36:46 Re: function permissions question
Previous Message Greg Steffensen 2007-12-09 05:21:15 function permissions question