Обсуждение: 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
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

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@ucdavis.edu

On 11/01/2008, Bborie Park <bkpark@ucdavis.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