Web pgadmin.org
 Home 
 ·  ·  ·  ·  ·  ·  · 
Bug in language privileges

Bug in language privileges



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

--
Bborie Park
Programmer
Center for Vectorborne Diseases
UC Davis
530-752-8380
bkpark(at)ucdavis(dot)edu



Home | Main Index | Thread Index

top