Re: Bug in language privileges

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

Sorry about that...
-- 
Bborie Park
Programmer
Center for Vectorborne Diseases
UC Davis
530-752-8380
bkpark@ucdavis.edu