Re: Bug in language privileges

On 11/01/2008, Bborie Park <bkpark@ucdavis.edu> wrote:
> Bborie Park wrote:
> > Howdy,
> >
> > I believe there is a bug in assigning language privileges.  When
> > attempting to grant privileges, all actions use REVOKE instead of GRANT.
> >  For that matter, when viewing a language's details in the SQL pane, all
> > privileges are displayed as REVOKE rather than GRANT though the ACL in
> > the Properties tab says otherwise.
> >
> > For example...
> >
> > SQL pane:
> >
> > -- Language: plpgsql
> >
> > -- DROP LANGUAGE plpgsql;
> >
> >  CREATE TRUSTED PROCEDURAL LANGUAGE 'plpgsql'
> >   HANDLER plpgsql_call_handler
> >   VALIDATOR plpgsql_validator;
> > REVOKE ALL ON LANGUAGE plpgsql FROM sa;
> > REVOKE ALL ON LANGUAGE plpgsql FROM "\""Server Administrators\""";
> > REVOKE ALL ON LANGUAGE plpgsql FROM gateway;
> >
> > ACL from Properties:
> >
> > {sa=U/sa,"\"Server Administrators\"=U/sa",gateway=U/sa}
> >
> > Thanks,
> > Bborie
> >
>
> Whoops.  Forgot to add additional details:
>
> pgAdminIII 1.8.1
> Windows XP SP2

Thanks - fixed in SVN for 1.8.2.

Regards, Dave