Re: Function's access control list ambiguity

[Dave Page <dpage(at)pgadmin(dot)org>]

On Mon, Oct 5, 2009 at 12:48 PM, Dmitry Samokhin <sdld(at)mail(dot)ru> 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 OR REPLACE FUNCTION ... ;
> ALTER FUNCTION ... OWNER TO <owner>;
> REVOKE ALL ON FUNCTION ... FROM public;
> REVOKE ALL ON FUNCTION ... FROM <owner>;

Thanks, fixed in SVN for 1.10.1.

-- 
Dave Page
EnterpriseDB UK:   http://www.enterprisedb.com