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

2009-10-13 Thread Dave Page
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

[pgadmin-support] Function's access control list ambiguity

2009-10-05 Thread Dmitry Samokhin
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