Re: default EXECUTE privilege - Mailing list pgsql-general

From Tom Lane
Subject Re: default EXECUTE privilege
Date
Msg-id 14133.1062773309@sss.pgh.pa.us
Whole thread Raw
In response to default EXECUTE privilege  (Sergey Suleymanov <solt@eatpbank.ru>)
Responses Re: default EXECUTE privilege  (Lincoln Yeoh <lyeoh@pop.jaring.my>)
List pgsql-general
Sergey Suleymanov <solt@eatpbank.ru> writes:
>        Documentation says "By default, only the owner (creator) of the
>        function has the right to execute it."

That's a documentation error.  Where do you see it exactly?  I can't
find such a statement in the current sources.

>        But for me newly created function has execute privilege to
>        public by default. And we have to execute "revoke execute on
>        function ... from public". Why?

We decided that was the most useful default.

            regards, tom lane

pgsql-general by date:

Previous
From: "scott.marlowe"
Date:
Subject: Re: Pagination - 1 or 2 queries?
Next
From: Tom Lane
Date:
Subject: Re: Replaceing records