On Mon, Oct 5, 2009 at 12:48 PM, Dmitry Samokhin wrote:
> To implement this in case of empty, but not null, ACL of functions (and
> other database objects granting default access to PUBLIC), the
> reverse-engineering procedure of pgAdmin might be modified for the script to
> look like:
>
> CREATE
When a new function is created, the initial default EXECUTE privilege is
granted to PUBLIC (this is described is the documentation), and pgAdmin
generates the followng script:
CREATE OR REPLACE FUNCTION ... ;
ALTER FUNCTION ... OWNER TO ...;
The function's ACL is dispayed in the 'ACL' field in