From: | Bborie Park <bkpark(at)ucdavis(dot)edu> |
---|---|
To: | pgadmin-support(at)postgresql(dot)org |
Subject: | Re: Bug in language privileges |
Date: | 2008-01-11 23:22:56 |
Message-ID: | 4787FA50.8050603@ucdavis.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
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(at)ucdavis(dot)edu
From | Date | Subject | |
---|---|---|---|
Next Message | Andy Shellam | 2008-01-13 14:30:03 | New sequence in 1.8.1 |
Previous Message | Bborie Park | 2008-01-11 23:09:53 | Bug in language privileges |