| From: | Bborie Park <bkpark(at)ucdavis(dot)edu> |
|---|---|
| To: | pgadmin-support(at)postgresql(dot)org |
| Subject: | Bug in language privileges |
| Date: | 2008-01-11 23:09:53 |
| Message-ID: | 4787F741.401@ucdavis.edu |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bborie Park | 2008-01-11 23:22:56 | Re: Bug in language privileges |
| Previous Message | kristoff | 2008-01-11 17:31:28 | pgagent run results. Where are they ??? :) |