Re: dblink connection security - Mailing list pgsql-patches

From Joe Conway
Subject Re: dblink connection security
Date
Msg-id 468818A9.4020700@joeconway.com
Whole thread Raw
In response to Re: dblink connection security  (Robert Treat <xzilla@users.sourceforge.net>)
Responses Re: dblink connection security  (Joe Conway <mail@joeconway.com>)
List pgsql-patches
Robert Treat wrote:
>>> Joe Conway <mail@joeconway.com> writes:
>> Well certainly dbi-link has the exact same issue.
>
> dbi-link only works in plperlu, so you've already decided your superuser only.

How so -- it is fundamentally no different than dblink, which is C
language (also untrusted).

I think the issue is that once the superuser creates said functions,
usage of the functions is automatically granted to PUBLIC, no? Being an
untrusted language just means that it takes a superuser to create the
functions using that language, not to use the functions themselves.

Joe


pgsql-patches by date:

Previous
From: Tom Lane
Date:
Subject: Re: dblink connection security
Next
From: Gregory Stark
Date:
Subject: Re: dblink connection security