Security implications of untrusted triggers - Mailing list pgsql-general

From Joshua Kramer
Subject Security implications of untrusted triggers
Date
Msg-id Pine.LNX.4.63.0601121325030.24101@localhost.localdomain
Whole thread Raw
Responses Re: Security implications of untrusted triggers
List pgsql-general
Or more specifically, what are the security implications of a trigger
written in an untrusted language - PL/PerlU?

With a standard stored procedure, you have the possibility of an
SQL-injection attack.  Is this possible with a trigger function, if it is
defined as a trigger?

I am writing a couple of Perl modules that talk to the outside world: one
talks to a database (via DBI), and one talks to a Jabber/XMPP server.  I
want to use these from within a Trigger.  Do I have to taint-check the
input provided by the trigger mechanism - or does PG do this?

Thanks,
-Josh


pgsql-general by date:

Previous
From: Claire McLister
Date:
Subject: Re: Large object restore problem w/triggers
Next
From: "Joshua D. Drake"
Date:
Subject: Re: Plans for 8.2?