Re: dblink connection security - Mailing list pgsql-patches

From Stephen Frost
Subject Re: dblink connection security
Date
Msg-id 20070709043037.GU4887@tamriel.snowman.net
Whole thread Raw
In response to Re: dblink connection security  (Gregory Stark <stark@enterprisedb.com>)
List pgsql-patches
* Gregory Stark (stark@enterprisedb.com) wrote:
> "Joe Conway" <mail@joeconway.com> writes:
> > Consider a scenario like "package <x> uses <arbitrary function y in an
> > untrusted language z>". Exact same concerns arise.
>
> Well arbitrary function may or may not actually do anything that needs to be
> restricted.
>
> If it does then yes the same concerns arise and the same conclusion reached.
> That users should be granted permission to execute it based on local policies.
> Certainly granting execute permission to public by default is a bad start in
> that regard.

Agreed, and regardless of the sysadmin doing x, y, or z, or what some
other package might be doing with untrusted languages, what matters here
is what we're doing and the functions we're providing.  Best practice is
to disable functions by default which aren't safe & secure for users to
have access to.

If you know of any others in anything we're distributing, please point
them out.  If there are some in related projects, point those out and
ask those projects to be careful with them and encourage them to disable
them by default.

    Thanks,

        Stephen

Attachment

pgsql-patches by date:

Previous
From: Gregory Stark
Date:
Subject: Re: dblink connection security
Next
From: Joe Conway
Date:
Subject: Re: dblink connection security