Re: default EXECUTE privilege

Last line just before EXAMPLES
http://www.us.postgresql.org/postgresql-7.3.3/sql-createfunction.html

Highlighted:

http://216.239.33.104/search?q=cache:soHhFN4V1IMJ:www.us.postgresql.org/postgresql-7.3.3/sql-createfunction.html++site:www.us.postgresql.org+default,+only+the+owner+%22%2Bof+%2Bthe+function%22++right+to+execute+it&hl=en&ie=UTF-8

At 10:48 AM 9/5/2003 -0400, Tom Lane wrote:

>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
>
>---------------------------(end of broadcast)---------------------------
>TIP 4: Don't 'kill -9' the postmaster