Bug in language privileges
От | Bborie Park |
---|---|
Тема | Bug in language privileges |
Дата | |
Msg-id | 4787F741.401@ucdavis.edu обсуждение исходный текст |
Ответы |
Re: Bug in language privileges
|
Список | pgadmin-support |
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 detailsin 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@ucdavis.edu
В списке pgadmin-support по дате отправления: