Re: default EXECUTE privilege - Mailing list pgsql-general

From Tom Lane
Subject Re: default EXECUTE privilege
Date
Msg-id 17596.1062776090@sss.pgh.pa.us
Whole thread Raw
In response to Re: default EXECUTE privilege  (Lincoln Yeoh <lyeoh@pop.jaring.my>)
List pgsql-general
Lincoln Yeoh <lyeoh@pop.jaring.my> writes:
>> That's a documentation error.  Where do you see it exactly?  I can't
>> find such a statement in the current sources.

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

Ah.  Looks like it's already been removed from the 7.4 docs.

The GRANT reference page does state the situation correctly:

Depending on the type of object, the initial default privileges may
include granting some privileges to PUBLIC. The default is no public
access for tables and schemas; TEMP table creation privilege for
databases; EXECUTE privilege for functions; and USAGE privilege for
languages. The object creator may of course revoke these privileges.

            regards, tom lane

pgsql-general by date:

Previous
From: Vivek Khera
Date:
Subject: Re: Backup?
Next
From: Ron Johnson
Date:
Subject: Re: [PERFORM] Seq scan of table?