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(at)eatpbank(dot)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