Security implications of untrusted triggers

From: Joshua Kramer <josh(at)bitbuckets(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Security implications of untrusted triggers
Date: 2006-01-12 18:29:45
Message-ID: Pine.LNX.4.63.0601121325030.24101@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Joshua D. Drake 2006-01-12 18:36:39 Re: Plans for 8.2?
Previous Message Claire McLister 2006-01-12 18:28:24 Re: Large object restore problem w/triggers