Re: has_language_privilege returns incorrect answer for non-superuser - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: has_language_privilege returns incorrect answer for non-superuser
Date
Msg-id 20160414171150.GA197197@alvherre.pgsql
Whole thread Raw
In response to has_language_privilege returns incorrect answer for non-superuser  (Joe Conway <mail@joeconway.com>)
Responses Re: has_language_privilege returns incorrect answer for non-superuser  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Joe Conway wrote:
> I noticed today that has_language_privilege() returns incorrect answer
> for non-superuser, e.g.:
> 
> 8<---------------------------------------------------
> select has_language_privilege('nobody',
>                               'plperlu',
>                               'usage');
>  has_language_privilege
> ------------------------
>  t
> (1 row)

Funnily enough, this is still the case in 9.6, four years later.  Have
we made any inroads in fixing this?

-- 
Álvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services



pgsql-hackers by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: Pglogical questions and problems
Next
From: Tom Lane
Date:
Subject: Re: has_language_privilege returns incorrect answer for non-superuser