CentOS 4 / 5 : postgresql / postgresql84 (CESA-2010:0742)

medium Nessus Plugin ID 49781

Language:

Synopsis

The remote CentOS host is missing one or more security updates.

Description

Updated postgresql and postgresql84 packages that fix one security issue are now available for Red Hat Enterprise Linux 4 and 5.

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.

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)

For Red Hat Enterprise Linux 4, the updated postgresql packages upgrade PostgreSQL to version 7.4.30. Refer to the PostgreSQL Release Notes for a list of changes :

http://www.postgresql.org/docs/7.4/static/release.html

For Red Hat Enterprise Linux 5, the updated postgresql packages upgrade PostgreSQL to version 8.1.22, and the updated postgresql84 packages upgrade PostgreSQL to version 8.4.5. Refer to the PostgreSQL Release Notes for a list of changes :

http://www.postgresql.org/docs/8.1/static/release.html http://www.postgresql.org/docs/8.4/static/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.

Solution

Update the affected postgresql and / or postgresql84 packages.

See Also

http://www.nessus.org/u?a6b900bd

http://www.nessus.org/u?8db1b87a

http://www.nessus.org/u?0f1ca1b9

http://www.nessus.org/u?c606304d

http://www.nessus.org/u?90d24913

http://www.nessus.org/u?6c7b6902

Plugin Details

Severity: Medium

ID: 49781

File Name: centos_RHSA-2010-0742.nasl

Version: 1.15

Type: local

Agent: unix

Published: 10/7/2010

Updated: 1/4/2021

Supported Sensors: Frictionless Assessment AWS, Frictionless Assessment Azure, Frictionless Assessment Agent, Agentless Assessment, Nessus

Risk Information

VPR

Risk Factor: Low

Score: 3.4

CVSS v2

Risk Factor: Medium

Base Score: 6

Temporal Score: 4.4

Vector: CVSS2#AV:N/AC:M/Au:S/C:P/I:P/A:P

Vulnerability Information

CPE: p-cpe:/a:centos:centos:postgresql, p-cpe:/a:centos:centos:postgresql-contrib, p-cpe:/a:centos:centos:postgresql-devel, p-cpe:/a:centos:centos:postgresql-docs, p-cpe:/a:centos:centos:postgresql-jdbc, p-cpe:/a:centos:centos:postgresql-libs, p-cpe:/a:centos:centos:postgresql-pl, p-cpe:/a:centos:centos:postgresql-python, p-cpe:/a:centos:centos:postgresql-server, p-cpe:/a:centos:centos:postgresql-tcl, p-cpe:/a:centos:centos:postgresql-test, p-cpe:/a:centos:centos:postgresql84, p-cpe:/a:centos:centos:postgresql84-contrib, p-cpe:/a:centos:centos:postgresql84-devel, p-cpe:/a:centos:centos:postgresql84-docs, p-cpe:/a:centos:centos:postgresql84-libs, p-cpe:/a:centos:centos:postgresql84-plperl, p-cpe:/a:centos:centos:postgresql84-plpython, p-cpe:/a:centos:centos:postgresql84-pltcl, p-cpe:/a:centos:centos:postgresql84-python, p-cpe:/a:centos:centos:postgresql84-server, p-cpe:/a:centos:centos:postgresql84-tcl, p-cpe:/a:centos:centos:postgresql84-test, cpe:/o:centos:centos:4, cpe:/o:centos:centos:5

Required KB Items: Host/local_checks_enabled, Host/CentOS/release, Host/CentOS/rpm-list

Exploit Ease: No known exploits are available

Patch Publication Date: 10/11/2010

Vulnerability Publication Date: 10/6/2010

Reference Information

CVE: CVE-2010-3433

BID: 43747

RHSA: 2010:0742