From: | "Dave Page" <dpage(at)postgresql(dot)org> |
---|---|
To: | "Bborie Park" <bkpark(at)ucdavis(dot)edu> |
Cc: | pgadmin-support(at)postgresql(dot)org |
Subject: | Re: Bug in language privileges |
Date: | 2008-01-14 11:07:22 |
Message-ID: | 937d27e10801140307r61ea5355tcbce52a3923a627b@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
On 11/01/2008, Bborie Park <bkpark(at)ucdavis(dot)edu> wrote:
> 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
Thanks - fixed in SVN for 1.8.2.
Regards, Dave
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Page | 2008-01-14 13:02:51 | Re: New sequence in 1.8.1 |
Previous Message | Guillaume Lelarge | 2008-01-14 09:12:14 | Re: New sequence in 1.8.1 |