Re: Howto create a plperlu function as user (not superuser)??

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Brent Wood <b(dot)wood(at)niwa(dot)co(dot)nz>
Cc: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Howto create a plperlu function as user (not superuser)??
Date: 2005-09-15 02:57:45
Message-ID: 9384.1126753065@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Brent Wood <b(dot)wood(at)niwa(dot)co(dot)nz> writes:
> That is not me. Sigh. Is there any way I can develop (with the various
> "create or replace function" iterations this wiil probably require) this
> plperlu function as a non superuser?

If you could, it would be a security hole, which we would fix with
utmost alacrity. Untrusted-language functions may only be created
by superusers.

Can you compartmentalize the depth-accessing function as a small
plperlu function, and do all the interesting stuff in plain plperl
atop that?

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Brent Wood 2005-09-15 03:57:50 Re: Howto create a plperlu function as user (not superuser)??
Previous Message John Fabiani 2005-09-15 02:06:19 Re: Speed problems