Re: default EXECUTE privilege - Mailing list pgsql-general

From Lincoln Yeoh
Subject Re: default EXECUTE privilege
Date
Msg-id 5.2.1.1.1.20030905231526.01ea1ce8@mbox.jaring.my
Whole thread Raw
In response to Re: default EXECUTE privilege  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: default EXECUTE privilege
List pgsql-general
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


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Replaceing records
Next
From: Vivek Khera
Date:
Subject: Re: Backup?