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

From Tom Lane
Subject Re: has_language_privilege returns incorrect answer for non-superuser
Date
Msg-id 12315.1342130034@sss.pgh.pa.us
Whole thread Raw
In response to Re: has_language_privilege returns incorrect answer for non-superuser  (Peter Eisentraut <peter_e@gmx.net>)
Responses Re: has_language_privilege returns incorrect answer for non-superuser  (Joe Conway <mail@joeconway.com>)
List pgsql-hackers
Peter Eisentraut <peter_e@gmx.net> writes:
> As long as we're spending time on this, I'd propose getting rid of
> lanplistrusted, at least for access checking.  Instead, just don't
> install USAGE privileges by default for those languages.

There's definitely something to that idea --- certainly lanpltrusted
dates from before we had a robust object-permissions system, and looks
like a bit of a wart now that we do have one.

I guess we could redefine the default privileges for languages as "none"
and then have the TRUSTED keyword mean to install public usage
privilege.  Or maybe it would be safer for upgrade purposes if we kept
the default interpretation as-is and did an automatic REVOKE when
TRUSTED wasn't specified.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: has_language_privilege returns incorrect answer for non-superuser
Next
From: Gurjeet Singh
Date:
Subject: Re: FW: Allow replacement of bloated primary key indexes without foreign key rebuilds