Bug 639371 (CVE-2010-3433) - CVE-2010-3433 PostgreSQL (PL/Perl, PL/Tcl): SECURITY DEFINER function keyword bypass
Summary: CVE-2010-3433 PostgreSQL (PL/Perl, PL/Tcl): SECURITY DEFINER function keyword...
Alias: CVE-2010-3433
Product: Security Response
Classification: Other
Component: vulnerability
Version: unspecified
Hardware: All
OS: Linux
Target Milestone: ---
Assignee: Red Hat Product Security
QA Contact:
Depends On: 639928 639929 639930 639931 639932 639933 639934 640069 640090 640433 812235 812242
TreeView+ depends on / blocked
Reported: 2010-10-01 15:11 UTC by Jan Lieskovsky
Modified: 2019-09-29 12:39 UTC (History)
3 users (show)

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Last Closed: 2012-10-07 16:52:24 UTC

Attachments (Terms of Use)

System ID Private Priority Status Summary Last Updated
Red Hat Product Errata RHSA-2010:0742 0 normal SHIPPED_LIVE Moderate: postgresql and postgresql84 security update 2010-10-06 10:29:19 UTC
Red Hat Product Errata RHSA-2010:0908 0 normal SHIPPED_LIVE Moderate: postgresql security update 2010-11-23 16:00:10 UTC

Description Jan Lieskovsky 2010-10-01 15:11:42 UTC
A flaw was found in the way PostgreSQL handled SQL functions, created
with SECURITY DEFINER keyword and implemented in PL/Perl or PL/Tcl
languages. Once the PL/Perl or PL/Tcl procedural language was registered
on particular database, a remote, authenticated user, running a
specially-crafted PL/Perl or PL/Tcl script could use this flaw to bypass
intended PostgreSQL SECURITY DEFINER function definition refinement /
protection mechanism, allowing them to run particular PostgreSQL function
under their effective user ID, potentially leading to escalation of their

[1] http://www.postgresql.org/docs/8.1/interactive/plperl.html
[2] http://www.postgresql.org/docs/8.1/static/pltcl.html
[3] http://www.postgresql.org/docs/8.1/interactive/sql-createfunction.html

Comment 13 Jan Lieskovsky 2010-10-05 19:36:41 UTC
Created postgresql tracking bugs for this issue

Affects: fedora-all [bug 640433]

Comment 14 errata-xmlrpc 2010-10-06 10:29:34 UTC
This issue has been addressed in following products:

  Red Hat Enterprise Linux 4
  Red Hat Enterprise Linux 5

Via RHSA-2010:0742 https://rhn.redhat.com/errata/RHSA-2010-0742.html

Comment 15 Tomas Hoger 2010-10-06 16:39:55 UTC
Upstream wiki page with additional details and FAQ:

Comment 16 errata-xmlrpc 2010-11-23 16:00:18 UTC
This issue has been addressed in following products:

  Red Hat Enterprise Linux 6

Via RHSA-2010:0908 https://rhn.redhat.com/errata/RHSA-2010-0908.html

Note You need to log in before you can comment on or make changes to this bug.