====================================================================                   Red Hat Security Advisory

Synopsis:          Moderate: postgresql security update
Advisory ID:       RHSA-2010:0908-01
Product:           Red Hat Enterprise Linux
Advisory URL:      https://access.redhat.com/errata/RHSA-2010:0908.html
Issue date:        2010-11-23
CVE Names:         CVE-2010-3433 
====================================================================
1. Summary:

Updated postgresql packages that fix one security issue are now available
for Red Hat Enterprise Linux 6.

The Red Hat Security Response Team has rated this update as having moderate
security impact. A Common Vulnerability Scoring System (CVSS) base score,
which gives a detailed severity rating, is available from the CVE link in
the References section.

2. Relevant releases/architectures:

Red Hat Enterprise Linux Desktop (v. 6) - i386, x86_64
Red Hat Enterprise Linux Desktop Optional (v. 6) - i386, x86_64
Red Hat Enterprise Linux HPC Node Optional (v. 6) - x86_64
Red Hat Enterprise Linux Server (v. 6) - i386, ppc64, s390x, x86_64
Red Hat Enterprise Linux Workstation (v. 6) - i386, x86_64

3. Description:

PostgreSQL is an advanced object-relational database management system
(DBMS). PL/Perl and PL/Tcl allow users to write PostgreSQL functions in the
Perl and Tcl languages. The PostgreSQL SECURITY DEFINER parameter, which
can be used when creating a new PostgreSQL function, specifies that the
function will be executed with the privileges of the user that created it.

It was discovered that a user could utilize the features of the PL/Perl and
PL/Tcl languages to modify the behavior of a SECURITY DEFINER function
created by a different user. If the PL/Perl or PL/Tcl language was used to
implement a SECURITY DEFINER function, an authenticated database user could
use a PL/Perl or PL/Tcl script to modify the behavior of that function
during subsequent calls in the same session. This would result in the
modified or injected code also being executed with the privileges of the
user who created the SECURITY DEFINER function, possibly leading to
privilege escalation. (CVE-2010-3433)

These updated postgresql packages upgrade PostgreSQL to version 8.4.5.
Refer to the PostgreSQL Release Notes for a list of changes:

https://www.postgresql.org/docs/8.4/release.html

All PostgreSQL users are advised to upgrade to these updated packages,
which correct this issue. If the postgresql service is running, it will be
automatically restarted after installing this update.

4. Solution:

Before applying this update, make sure all previously-released errata
relevant to your system have been applied.

This update is available via the Red Hat Network. Details on how to
use the Red Hat Network to apply this update are available at

5. Bugs fixed (http://bugzilla.redhat.com/):

639371 - CVE-2010-3433 PostgreSQL (PL/Perl, PL/Tcl): SECURITY DEFINER function keyword bypass

6. Package List:

Red Hat Enterprise Linux Desktop (v. 6):

Source:

i386:
postgresql-debuginfo-8.4.5-1.el6_0.2.i686.rpm
postgresql-libs-8.4.5-1.el6_0.2.i686.rpm

x86_64:
postgresql-debuginfo-8.4.5-1.el6_0.2.i686.rpm
postgresql-debuginfo-8.4.5-1.el6_0.2.x86_64.rpm
postgresql-libs-8.4.5-1.el6_0.2.i686.rpm
postgresql-libs-8.4.5-1.el6_0.2.x86_64.rpm

Red Hat Enterprise Linux Desktop Optional (v. 6):

Source:

i386:
postgresql-8.4.5-1.el6_0.2.i686.rpm
postgresql-contrib-8.4.5-1.el6_0.2.i686.rpm
postgresql-debuginfo-8.4.5-1.el6_0.2.i686.rpm
postgresql-devel-8.4.5-1.el6_0.2.i686.rpm
postgresql-docs-8.4.5-1.el6_0.2.i686.rpm
postgresql-plperl-8.4.5-1.el6_0.2.i686.rpm
postgresql-plpython-8.4.5-1.el6_0.2.i686.rpm
postgresql-pltcl-8.4.5-1.el6_0.2.i686.rpm
postgresql-server-8.4.5-1.el6_0.2.i686.rpm
postgresql-test-8.4.5-1.el6_0.2.i686.rpm

x86_64:
postgresql-8.4.5-1.el6_0.2.x86_64.rpm
postgresql-contrib-8.4.5-1.el6_0.2.x86_64.rpm
postgresql-debuginfo-8.4.5-1.el6_0.2.i686.rpm
postgresql-debuginfo-8.4.5-1.el6_0.2.x86_64.rpm
postgresql-devel-8.4.5-1.el6_0.2.i686.rpm
postgresql-devel-8.4.5-1.el6_0.2.x86_64.rpm
postgresql-docs-8.4.5-1.el6_0.2.x86_64.rpm
postgresql-plperl-8.4.5-1.el6_0.2.x86_64.rpm
postgresql-plpython-8.4.5-1.el6_0.2.x86_64.rpm
postgresql-pltcl-8.4.5-1.el6_0.2.x86_64.rpm
postgresql-server-8.4.5-1.el6_0.2.x86_64.rpm
postgresql-test-8.4.5-1.el6_0.2.x86_64.rpm

Red Hat Enterprise Linux HPC Node Optional (v. 6):

Source:

x86_64:
postgresql-8.4.5-1.el6_0.2.x86_64.rpm
postgresql-contrib-8.4.5-1.el6_0.2.x86_64.rpm
postgresql-debuginfo-8.4.5-1.el6_0.2.i686.rpm
postgresql-debuginfo-8.4.5-1.el6_0.2.x86_64.rpm
postgresql-devel-8.4.5-1.el6_0.2.i686.rpm
postgresql-devel-8.4.5-1.el6_0.2.x86_64.rpm
postgresql-docs-8.4.5-1.el6_0.2.x86_64.rpm
postgresql-libs-8.4.5-1.el6_0.2.i686.rpm
postgresql-libs-8.4.5-1.el6_0.2.x86_64.rpm
postgresql-plperl-8.4.5-1.el6_0.2.x86_64.rpm
postgresql-plpython-8.4.5-1.el6_0.2.x86_64.rpm
postgresql-pltcl-8.4.5-1.el6_0.2.x86_64.rpm
postgresql-server-8.4.5-1.el6_0.2.x86_64.rpm
postgresql-test-8.4.5-1.el6_0.2.x86_64.rpm

Red Hat Enterprise Linux Server (v. 6):

Source:

i386:
postgresql-8.4.5-1.el6_0.2.i686.rpm
postgresql-contrib-8.4.5-1.el6_0.2.i686.rpm
postgresql-debuginfo-8.4.5-1.el6_0.2.i686.rpm
postgresql-devel-8.4.5-1.el6_0.2.i686.rpm
postgresql-docs-8.4.5-1.el6_0.2.i686.rpm
postgresql-libs-8.4.5-1.el6_0.2.i686.rpm
postgresql-plperl-8.4.5-1.el6_0.2.i686.rpm
postgresql-plpython-8.4.5-1.el6_0.2.i686.rpm
postgresql-pltcl-8.4.5-1.el6_0.2.i686.rpm
postgresql-server-8.4.5-1.el6_0.2.i686.rpm
postgresql-test-8.4.5-1.el6_0.2.i686.rpm

ppc64:
postgresql-8.4.5-1.el6_0.2.ppc64.rpm
postgresql-contrib-8.4.5-1.el6_0.2.ppc64.rpm
postgresql-debuginfo-8.4.5-1.el6_0.2.ppc.rpm
postgresql-debuginfo-8.4.5-1.el6_0.2.ppc64.rpm
postgresql-devel-8.4.5-1.el6_0.2.ppc.rpm
postgresql-devel-8.4.5-1.el6_0.2.ppc64.rpm
postgresql-docs-8.4.5-1.el6_0.2.ppc64.rpm
postgresql-libs-8.4.5-1.el6_0.2.ppc.rpm
postgresql-libs-8.4.5-1.el6_0.2.ppc64.rpm
postgresql-plperl-8.4.5-1.el6_0.2.ppc64.rpm
postgresql-plpython-8.4.5-1.el6_0.2.ppc64.rpm
postgresql-pltcl-8.4.5-1.el6_0.2.ppc64.rpm
postgresql-server-8.4.5-1.el6_0.2.ppc64.rpm
postgresql-test-8.4.5-1.el6_0.2.ppc64.rpm

s390x:
postgresql-8.4.5-1.el6_0.2.s390x.rpm
postgresql-contrib-8.4.5-1.el6_0.2.s390x.rpm
postgresql-debuginfo-8.4.5-1.el6_0.2.s390.rpm
postgresql-debuginfo-8.4.5-1.el6_0.2.s390x.rpm
postgresql-devel-8.4.5-1.el6_0.2.s390.rpm
postgresql-devel-8.4.5-1.el6_0.2.s390x.rpm
postgresql-docs-8.4.5-1.el6_0.2.s390x.rpm
postgresql-libs-8.4.5-1.el6_0.2.s390.rpm
postgresql-libs-8.4.5-1.el6_0.2.s390x.rpm
postgresql-plperl-8.4.5-1.el6_0.2.s390x.rpm
postgresql-plpython-8.4.5-1.el6_0.2.s390x.rpm
postgresql-pltcl-8.4.5-1.el6_0.2.s390x.rpm
postgresql-server-8.4.5-1.el6_0.2.s390x.rpm
postgresql-test-8.4.5-1.el6_0.2.s390x.rpm

x86_64:
postgresql-8.4.5-1.el6_0.2.x86_64.rpm
postgresql-contrib-8.4.5-1.el6_0.2.x86_64.rpm
postgresql-debuginfo-8.4.5-1.el6_0.2.i686.rpm
postgresql-debuginfo-8.4.5-1.el6_0.2.x86_64.rpm
postgresql-devel-8.4.5-1.el6_0.2.i686.rpm
postgresql-devel-8.4.5-1.el6_0.2.x86_64.rpm
postgresql-docs-8.4.5-1.el6_0.2.x86_64.rpm
postgresql-libs-8.4.5-1.el6_0.2.i686.rpm
postgresql-libs-8.4.5-1.el6_0.2.x86_64.rpm
postgresql-plperl-8.4.5-1.el6_0.2.x86_64.rpm
postgresql-plpython-8.4.5-1.el6_0.2.x86_64.rpm
postgresql-pltcl-8.4.5-1.el6_0.2.x86_64.rpm
postgresql-server-8.4.5-1.el6_0.2.x86_64.rpm
postgresql-test-8.4.5-1.el6_0.2.x86_64.rpm

Red Hat Enterprise Linux Workstation (v. 6):

Source:

i386:
postgresql-8.4.5-1.el6_0.2.i686.rpm
postgresql-contrib-8.4.5-1.el6_0.2.i686.rpm
postgresql-debuginfo-8.4.5-1.el6_0.2.i686.rpm
postgresql-devel-8.4.5-1.el6_0.2.i686.rpm
postgresql-docs-8.4.5-1.el6_0.2.i686.rpm
postgresql-libs-8.4.5-1.el6_0.2.i686.rpm
postgresql-plperl-8.4.5-1.el6_0.2.i686.rpm
postgresql-plpython-8.4.5-1.el6_0.2.i686.rpm
postgresql-pltcl-8.4.5-1.el6_0.2.i686.rpm
postgresql-server-8.4.5-1.el6_0.2.i686.rpm
postgresql-test-8.4.5-1.el6_0.2.i686.rpm

x86_64:
postgresql-8.4.5-1.el6_0.2.x86_64.rpm
postgresql-contrib-8.4.5-1.el6_0.2.x86_64.rpm
postgresql-debuginfo-8.4.5-1.el6_0.2.i686.rpm
postgresql-debuginfo-8.4.5-1.el6_0.2.x86_64.rpm
postgresql-devel-8.4.5-1.el6_0.2.i686.rpm
postgresql-devel-8.4.5-1.el6_0.2.x86_64.rpm
postgresql-docs-8.4.5-1.el6_0.2.x86_64.rpm
postgresql-libs-8.4.5-1.el6_0.2.i686.rpm
postgresql-libs-8.4.5-1.el6_0.2.x86_64.rpm
postgresql-plperl-8.4.5-1.el6_0.2.x86_64.rpm
postgresql-plpython-8.4.5-1.el6_0.2.x86_64.rpm
postgresql-pltcl-8.4.5-1.el6_0.2.x86_64.rpm
postgresql-server-8.4.5-1.el6_0.2.x86_64.rpm
postgresql-test-8.4.5-1.el6_0.2.x86_64.rpm

These packages are GPG signed by Red Hat for security.  Our key and 
details on how to verify the signature are available from
https://www.redhat.com/security/team/key/#package

7. References:

https://www.redhat.com/security/data/cve/CVE-2010-3433.html
http://www.redhat.com/security/updates/classification/#moderate
https://www.postgresql.org/docs/8.1/sql-createfunction.html
https://www.postgresql.org/docs/8.4/release.html

8. Contact:

The Red Hat security contact is .  More contact
details at https://www.redhat.com/security/team/contact/

Copyright 2010 Red Hat, Inc.

Red Hat: 2010:0908-01: postgresql: Moderate Advisory

Updated postgresql packages that fix one security issue are now available for Red Hat Enterprise Linux 6

Summary

PostgreSQL is an advanced object-relational database management system (DBMS). PL/Perl and PL/Tcl allow users to write PostgreSQL functions in the Perl and Tcl languages. The PostgreSQL SECURITY DEFINER parameter, which can be used when creating a new PostgreSQL function, specifies that the function will be executed with the privileges of the user that created it.
It was discovered that a user could utilize the features of the PL/Perl and PL/Tcl languages to modify the behavior of a SECURITY DEFINER function created by a different user. If the PL/Perl or PL/Tcl language was used to implement a SECURITY DEFINER function, an authenticated database user could use a PL/Perl or PL/Tcl script to modify the behavior of that function during subsequent calls in the same session. This would result in the modified or injected code also being executed with the privileges of the user who created the SECURITY DEFINER function, possibly leading to privilege escalation. (CVE-2010-3433)
These updated postgresql packages upgrade PostgreSQL to version 8.4.5. Refer to the PostgreSQL Release Notes for a list of changes:
https://www.postgresql.org/docs/8.4/release.html
All PostgreSQL users are advised to upgrade to these updated packages, which correct this issue. If the postgresql service is running, it will be automatically restarted after installing this update.

Summary

Solution

Before applying this update, make sure all previously-released errata relevant to your system have been applied.
This update is available via the Red Hat Network. Details on how to use the Red Hat Network to apply this update are available at

References

https://www.redhat.com/security/data/cve/CVE-2010-3433.html http://www.redhat.com/security/updates/classification/#moderate https://www.postgresql.org/docs/8.1/sql-createfunction.html https://www.postgresql.org/docs/8.4/release.html

Package List

Red Hat Enterprise Linux Desktop (v. 6):
Source:
i386: postgresql-debuginfo-8.4.5-1.el6_0.2.i686.rpm postgresql-libs-8.4.5-1.el6_0.2.i686.rpm
x86_64: postgresql-debuginfo-8.4.5-1.el6_0.2.i686.rpm postgresql-debuginfo-8.4.5-1.el6_0.2.x86_64.rpm postgresql-libs-8.4.5-1.el6_0.2.i686.rpm postgresql-libs-8.4.5-1.el6_0.2.x86_64.rpm
Red Hat Enterprise Linux Desktop Optional (v. 6):
Source:
i386: postgresql-8.4.5-1.el6_0.2.i686.rpm postgresql-contrib-8.4.5-1.el6_0.2.i686.rpm postgresql-debuginfo-8.4.5-1.el6_0.2.i686.rpm postgresql-devel-8.4.5-1.el6_0.2.i686.rpm postgresql-docs-8.4.5-1.el6_0.2.i686.rpm postgresql-plperl-8.4.5-1.el6_0.2.i686.rpm postgresql-plpython-8.4.5-1.el6_0.2.i686.rpm postgresql-pltcl-8.4.5-1.el6_0.2.i686.rpm postgresql-server-8.4.5-1.el6_0.2.i686.rpm postgresql-test-8.4.5-1.el6_0.2.i686.rpm
x86_64: postgresql-8.4.5-1.el6_0.2.x86_64.rpm postgresql-contrib-8.4.5-1.el6_0.2.x86_64.rpm postgresql-debuginfo-8.4.5-1.el6_0.2.i686.rpm postgresql-debuginfo-8.4.5-1.el6_0.2.x86_64.rpm postgresql-devel-8.4.5-1.el6_0.2.i686.rpm postgresql-devel-8.4.5-1.el6_0.2.x86_64.rpm postgresql-docs-8.4.5-1.el6_0.2.x86_64.rpm postgresql-plperl-8.4.5-1.el6_0.2.x86_64.rpm postgresql-plpython-8.4.5-1.el6_0.2.x86_64.rpm postgresql-pltcl-8.4.5-1.el6_0.2.x86_64.rpm postgresql-server-8.4.5-1.el6_0.2.x86_64.rpm postgresql-test-8.4.5-1.el6_0.2.x86_64.rpm
Red Hat Enterprise Linux HPC Node Optional (v. 6):
Source:
x86_64: postgresql-8.4.5-1.el6_0.2.x86_64.rpm postgresql-contrib-8.4.5-1.el6_0.2.x86_64.rpm postgresql-debuginfo-8.4.5-1.el6_0.2.i686.rpm postgresql-debuginfo-8.4.5-1.el6_0.2.x86_64.rpm postgresql-devel-8.4.5-1.el6_0.2.i686.rpm postgresql-devel-8.4.5-1.el6_0.2.x86_64.rpm postgresql-docs-8.4.5-1.el6_0.2.x86_64.rpm postgresql-libs-8.4.5-1.el6_0.2.i686.rpm postgresql-libs-8.4.5-1.el6_0.2.x86_64.rpm postgresql-plperl-8.4.5-1.el6_0.2.x86_64.rpm postgresql-plpython-8.4.5-1.el6_0.2.x86_64.rpm postgresql-pltcl-8.4.5-1.el6_0.2.x86_64.rpm postgresql-server-8.4.5-1.el6_0.2.x86_64.rpm postgresql-test-8.4.5-1.el6_0.2.x86_64.rpm
Red Hat Enterprise Linux Server (v. 6):
Source:
i386: postgresql-8.4.5-1.el6_0.2.i686.rpm postgresql-contrib-8.4.5-1.el6_0.2.i686.rpm postgresql-debuginfo-8.4.5-1.el6_0.2.i686.rpm postgresql-devel-8.4.5-1.el6_0.2.i686.rpm postgresql-docs-8.4.5-1.el6_0.2.i686.rpm postgresql-libs-8.4.5-1.el6_0.2.i686.rpm postgresql-plperl-8.4.5-1.el6_0.2.i686.rpm postgresql-plpython-8.4.5-1.el6_0.2.i686.rpm postgresql-pltcl-8.4.5-1.el6_0.2.i686.rpm postgresql-server-8.4.5-1.el6_0.2.i686.rpm postgresql-test-8.4.5-1.el6_0.2.i686.rpm
ppc64: postgresql-8.4.5-1.el6_0.2.ppc64.rpm postgresql-contrib-8.4.5-1.el6_0.2.ppc64.rpm postgresql-debuginfo-8.4.5-1.el6_0.2.ppc.rpm postgresql-debuginfo-8.4.5-1.el6_0.2.ppc64.rpm postgresql-devel-8.4.5-1.el6_0.2.ppc.rpm postgresql-devel-8.4.5-1.el6_0.2.ppc64.rpm postgresql-docs-8.4.5-1.el6_0.2.ppc64.rpm postgresql-libs-8.4.5-1.el6_0.2.ppc.rpm postgresql-libs-8.4.5-1.el6_0.2.ppc64.rpm postgresql-plperl-8.4.5-1.el6_0.2.ppc64.rpm postgresql-plpython-8.4.5-1.el6_0.2.ppc64.rpm postgresql-pltcl-8.4.5-1.el6_0.2.ppc64.rpm postgresql-server-8.4.5-1.el6_0.2.ppc64.rpm postgresql-test-8.4.5-1.el6_0.2.ppc64.rpm
s390x: postgresql-8.4.5-1.el6_0.2.s390x.rpm postgresql-contrib-8.4.5-1.el6_0.2.s390x.rpm postgresql-debuginfo-8.4.5-1.el6_0.2.s390.rpm postgresql-debuginfo-8.4.5-1.el6_0.2.s390x.rpm postgresql-devel-8.4.5-1.el6_0.2.s390.rpm postgresql-devel-8.4.5-1.el6_0.2.s390x.rpm postgresql-docs-8.4.5-1.el6_0.2.s390x.rpm postgresql-libs-8.4.5-1.el6_0.2.s390.rpm postgresql-libs-8.4.5-1.el6_0.2.s390x.rpm postgresql-plperl-8.4.5-1.el6_0.2.s390x.rpm postgresql-plpython-8.4.5-1.el6_0.2.s390x.rpm postgresql-pltcl-8.4.5-1.el6_0.2.s390x.rpm postgresql-server-8.4.5-1.el6_0.2.s390x.rpm postgresql-test-8.4.5-1.el6_0.2.s390x.rpm
x86_64: postgresql-8.4.5-1.el6_0.2.x86_64.rpm postgresql-contrib-8.4.5-1.el6_0.2.x86_64.rpm postgresql-debuginfo-8.4.5-1.el6_0.2.i686.rpm postgresql-debuginfo-8.4.5-1.el6_0.2.x86_64.rpm postgresql-devel-8.4.5-1.el6_0.2.i686.rpm postgresql-devel-8.4.5-1.el6_0.2.x86_64.rpm postgresql-docs-8.4.5-1.el6_0.2.x86_64.rpm postgresql-libs-8.4.5-1.el6_0.2.i686.rpm postgresql-libs-8.4.5-1.el6_0.2.x86_64.rpm postgresql-plperl-8.4.5-1.el6_0.2.x86_64.rpm postgresql-plpython-8.4.5-1.el6_0.2.x86_64.rpm postgresql-pltcl-8.4.5-1.el6_0.2.x86_64.rpm postgresql-server-8.4.5-1.el6_0.2.x86_64.rpm postgresql-test-8.4.5-1.el6_0.2.x86_64.rpm
Red Hat Enterprise Linux Workstation (v. 6):
Source:
i386: postgresql-8.4.5-1.el6_0.2.i686.rpm postgresql-contrib-8.4.5-1.el6_0.2.i686.rpm postgresql-debuginfo-8.4.5-1.el6_0.2.i686.rpm postgresql-devel-8.4.5-1.el6_0.2.i686.rpm postgresql-docs-8.4.5-1.el6_0.2.i686.rpm postgresql-libs-8.4.5-1.el6_0.2.i686.rpm postgresql-plperl-8.4.5-1.el6_0.2.i686.rpm postgresql-plpython-8.4.5-1.el6_0.2.i686.rpm postgresql-pltcl-8.4.5-1.el6_0.2.i686.rpm postgresql-server-8.4.5-1.el6_0.2.i686.rpm postgresql-test-8.4.5-1.el6_0.2.i686.rpm
x86_64: postgresql-8.4.5-1.el6_0.2.x86_64.rpm postgresql-contrib-8.4.5-1.el6_0.2.x86_64.rpm postgresql-debuginfo-8.4.5-1.el6_0.2.i686.rpm postgresql-debuginfo-8.4.5-1.el6_0.2.x86_64.rpm postgresql-devel-8.4.5-1.el6_0.2.i686.rpm postgresql-devel-8.4.5-1.el6_0.2.x86_64.rpm postgresql-docs-8.4.5-1.el6_0.2.x86_64.rpm postgresql-libs-8.4.5-1.el6_0.2.i686.rpm postgresql-libs-8.4.5-1.el6_0.2.x86_64.rpm postgresql-plperl-8.4.5-1.el6_0.2.x86_64.rpm postgresql-plpython-8.4.5-1.el6_0.2.x86_64.rpm postgresql-pltcl-8.4.5-1.el6_0.2.x86_64.rpm postgresql-server-8.4.5-1.el6_0.2.x86_64.rpm postgresql-test-8.4.5-1.el6_0.2.x86_64.rpm
These packages are GPG signed by Red Hat for security. Our key and details on how to verify the signature are available from https://www.redhat.com/security/team/key/#package

Severity

Advisory ID: RHSA-2010:0908-01

Product: Red Hat Enterprise Linux

Advisory URL: https://access.redhat.com/errata/RHSA-2010:0908.html

Issued Date: : 2010-11-23

CVE Names: CVE-2010-3433

Topic

Updated postgresql packages that fix one security issue are now availablefor Red Hat Enterprise Linux 6.The Red Hat Security Response Team has rated this update as having moderatesecurity impact. A Common Vulnerability Scoring System (CVSS) base score,which gives a detailed severity rating, is available from the CVE link inthe References section.