Ubuntu 6.06 LTS / 6.10 / 7.04 : postgresql-8.1, postgresql-8.2 vulnerability (USN-454-1)

medium Nessus Plugin ID 28052

Synopsis

The remote Ubuntu host is missing one or more security-related patches.

Description

PostgreSQL did not handle the 'search_path' configuration option in a secure way for functions declared as 'SECURITY DEFINER'.

Previously, an attacker could override functions and operators used by the security definer function to execute arbitrary SQL commands with the privileges of the user who created the security definer function.
The updated version does not search the temporary table schema for functions and operators any more.

Similarly, an attacker could put forged tables into the temporary table schema to trick the security definer function into using attacker defined data for processing. This was possible because the temporary schema was always implicitly searched first before all other entries in 'search_path'. The updated version now supports explicit placement of the temporary schema. Please see the HTML documentation or the manual page for 'CREATE FUNCTION' for details and an example how to write security definer functions in a secure way.

Note that Tenable Network Security has extracted the preceding description block directly from the Ubuntu security advisory. Tenable has attempted to automatically clean and format it as much as possible without introducing additional issues.

Solution

Update the affected packages.

See Also

https://usn.ubuntu.com/454-1/

Plugin Details

Severity: Medium

ID: 28052

File Name: ubuntu_USN-454-1.nasl

Version: 1.15

Type: local

Agent: unix

Published: 11/10/2007

Updated: 1/19/2021

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

Risk Information

VPR

Risk Factor: Medium

Score: 5.8

CVSS v2

Risk Factor: Medium

Base Score: 6

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

Vulnerability Information

CPE: p-cpe:/a:canonical:ubuntu_linux:libecpg-compat2, p-cpe:/a:canonical:ubuntu_linux:libecpg-dev, p-cpe:/a:canonical:ubuntu_linux:libecpg5, p-cpe:/a:canonical:ubuntu_linux:libpgtypes2, p-cpe:/a:canonical:ubuntu_linux:libpq-dev, p-cpe:/a:canonical:ubuntu_linux:libpq4, p-cpe:/a:canonical:ubuntu_linux:libpq5, p-cpe:/a:canonical:ubuntu_linux:postgresql-8.1, p-cpe:/a:canonical:ubuntu_linux:postgresql-8.2, p-cpe:/a:canonical:ubuntu_linux:postgresql-client-8.1, p-cpe:/a:canonical:ubuntu_linux:postgresql-client-8.2, p-cpe:/a:canonical:ubuntu_linux:postgresql-contrib-8.1, p-cpe:/a:canonical:ubuntu_linux:postgresql-contrib-8.2, p-cpe:/a:canonical:ubuntu_linux:postgresql-doc-8.1, p-cpe:/a:canonical:ubuntu_linux:postgresql-doc-8.2, p-cpe:/a:canonical:ubuntu_linux:postgresql-plperl-8.1, p-cpe:/a:canonical:ubuntu_linux:postgresql-plperl-8.2, p-cpe:/a:canonical:ubuntu_linux:postgresql-plpython-8.1, p-cpe:/a:canonical:ubuntu_linux:postgresql-plpython-8.2, p-cpe:/a:canonical:ubuntu_linux:postgresql-pltcl-8.1, p-cpe:/a:canonical:ubuntu_linux:postgresql-pltcl-8.2, p-cpe:/a:canonical:ubuntu_linux:postgresql-server-dev-8.1, p-cpe:/a:canonical:ubuntu_linux:postgresql-server-dev-8.2, cpe:/o:canonical:ubuntu_linux:6.06:-:lts, cpe:/o:canonical:ubuntu_linux:6.10, cpe:/o:canonical:ubuntu_linux:7.04

Required KB Items: Host/cpu, Host/Debian/dpkg-l, Host/Ubuntu, Host/Ubuntu/release

Patch Publication Date: 4/27/2007

Reference Information

CVE: CVE-2007-2138

USN: 454-1