Re: Function's access control list ambiguity - Mailing list pgadmin-support

From Dave Page
Subject Re: Function's access control list ambiguity
Date
Msg-id 937d27e10910130326g5aac2bb4j55b8c33900e6ac46@mail.gmail.com
Whole thread Raw
In response to Function's access control list ambiguity  ("Dmitry Samokhin" <sdld@mail.ru>)
List pgadmin-support
On Mon, Oct 5, 2009 at 12:48 PM, Dmitry Samokhin <sdld@mail.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


pgadmin-support by date:

Previous
From: "Dmitry Samokhin"
Date:
Subject: Re: Owner and privileges on sequences
Next
From: John
Date:
Subject: dropping connection