Re: plperl Safe restrictions

From: Jon Jensen <jon(at)endpoint(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: plperl Safe restrictions
Date: 2004-10-14 19:31:31
Message-ID: Pine.LNX.4.58.0410141926180.1268@louche.swelter.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches

On Thu, 14 Oct 2004, Andrew Dunstan wrote:

> It has just been brought to my attention that we are being very
> restrictive about what we allow to be done in trusted plperl. Basically
> we allow the :default and :base_math set of operations (run perldoc
> Opcode or see http://www.perldoc.com/perl5.8.0/lib/Opcode.html for
> details of what these mean). In particular, we do not allow calls to
> perl's builtin sort, which is unpleasant, and on reviewing the list it
> seems to me we could quite reasonably allow access to pack and unpack
> also. bless and sprintf are also likely candidates for inclusion - I
> have not finished reviewing the list, and would welcome advice from perl
> gurus on this.
>
> On the other side, I think we should exclude the :base_io set which is
> part of the :default set (we don't want trusted plperl writing to
> stdout, for example - all IO should be forbidden).

That makes sense. Allowing "rand" would be nice too.

Jon

--
Jon Jensen
End Point Corporation
http://www.endpoint.com/
Software development with Interchange, Perl, PostgreSQL, Apache, Linux, ...

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew Dunstan 2004-10-14 19:44:14 Re: plperl Safe restrictions
Previous Message Bruce Momjian 2004-10-14 19:26:39 Re: Problem with CIDR data type restrictions

Browse pgsql-patches by date

  From Date Subject
Next Message Andrew Dunstan 2004-10-14 19:44:14 Re: plperl Safe restrictions
Previous Message Andrew Dunstan 2004-10-14 19:09:42 plperl Safe restrictions