Re: dblink connection security - Mailing list pgsql-patches

From Joe Conway
Subject Re: dblink connection security
Date
Msg-id 4691B486.4090309@joeconway.com
Whole thread Raw
In response to Re: dblink connection security  (Stephen Frost <sfrost@snowman.net>)
Responses Re: dblink connection security
List pgsql-patches
Stephen Frost wrote:
> * Joe Conway (mail@joeconway.com) wrote:
>> Consider a scenario like "package <x> uses <arbitrary function y in an
>> untrusted language z>". Exact same concerns arise.
>
> No, it doesn't...  Said arbitrary function in y, in untrusted language
> z, could be perfectly safe for users to call.
      ^^^^^
*Could* be. But we just said that the admin was not interested in
reading the documentation, and has no idea if it *is* safe. And, it very
well might not be safe. We have no way to know in advance because the
language is untrusted.

> Being written in an untrusted language has got next to nothing to do with the security
> implications of a particular function.  It depends entirely on what the
> function is *doing*, not what language it's written in.

Sure it matters. A function written in a trusted language is known to be
safe, a priori. A function written in an untrusted language has no such
guarantees, and therefore has to be assumed unsafe unless carefully
proved otherwise.

Joe


pgsql-patches by date:

Previous
From: Gregory Stark
Date:
Subject: Re: dblink connection security
Next
From: Stephen Frost
Date:
Subject: Re: dblink connection security