Re: function permissions question - Mailing list pgsql-general

From Tom Lane
Subject Re: function permissions question
Date
Msg-id 3397.1197181103@sss.pgh.pa.us
Whole thread Raw
In response to function permissions question  ("Greg Steffensen" <greg.steffensen@gmail.com>)
Responses Re: function permissions question
List pgsql-general
"Greg Steffensen" <greg.steffensen@gmail.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

pgsql-general by date:

Previous
From: "Greg Steffensen"
Date:
Subject: function permissions question
Next
From: "Greg Steffensen"
Date:
Subject: Re: function permissions question