PostgreSQL search_path privilege escalation

postgresql-searchpath-privilege-escalation (33842) The risk level is classified as HighHigh Risk

Description:

PostgreSQL could allow a local or remote attacker to gain elevated privileges caused by insecure search_path settings. An attacker could modify the search_path and use specially-crafted temporary objects to obtain privileges of SECURITY DEFINER functions.

Platforms Affected:

  • Canonical, Ubuntu 6.06 LTS
  • Canonical, Ubuntu 6.10
  • Canonical, Ubuntu 7.04
  • Debian, Debian Linux 3.1
  • Debian, Debian Linux 4.0
  • Gentoo, Linux
  • MandrakeSoft, Mandrake Linux 2007
  • MandrakeSoft, Mandrake Linux 2007 X86_64
  • MandrakeSoft, Mandrake Linux 2007.1 X86_64
  • MandrakeSoft, Mandrake Linux 2007.1
  • MandrakeSoft, Mandrake Linux 2008.0 X86_64
  • MandrakeSoft, Mandrake Linux Corporate Server 3.0
  • MandrakeSoft, Mandrake Linux Corporate Server 3.0 X86_64
  • MandrakeSoft, Mandrake Linux Corporate Server 4.0
  • MandrakeSoft, Mandrake Linux Corporate Server 4.0 X86_64
  • PostgreSQL, PostgreSQL 7.3
  • PostgreSQL, PostgreSQL 7.3.1
  • PostgreSQL, PostgreSQL 7.3.10
  • PostgreSQL, PostgreSQL 7.3.11
  • PostgreSQL, PostgreSQL 7.3.12
  • PostgreSQL, PostgreSQL 7.3.13
  • PostgreSQL, PostgreSQL 7.3.14
  • PostgreSQL, PostgreSQL 7.3.15
  • PostgreSQL, PostgreSQL 7.3.16
  • PostgreSQL, PostgreSQL 7.3.17
  • PostgreSQL, PostgreSQL 7.3.18
  • PostgreSQL, PostgreSQL 7.3.2
  • PostgreSQL, PostgreSQL 7.3.3
  • PostgreSQL, PostgreSQL 7.3.4
  • PostgreSQL, PostgreSQL 7.3.5
  • PostgreSQL, PostgreSQL 7.3.6
  • PostgreSQL, PostgreSQL 7.3.7
  • PostgreSQL, PostgreSQL 7.3.8
  • PostgreSQL, PostgreSQL 7.3.9
  • PostgreSQL, PostgreSQL 7.4
  • PostgreSQL, PostgreSQL 7.4.1
  • PostgreSQL, PostgreSQL 7.4.10
  • PostgreSQL, PostgreSQL 7.4.11
  • PostgreSQL, PostgreSQL 7.4.12
  • PostgreSQL, PostgreSQL 7.4.13
  • PostgreSQL, PostgreSQL 7.4.14
  • PostgreSQL, PostgreSQL 7.4.15
  • PostgreSQL, PostgreSQL 7.4.16
  • PostgreSQL, PostgreSQL 7.4.2
  • PostgreSQL, PostgreSQL 7.4.3
  • PostgreSQL, PostgreSQL 7.4.4
  • PostgreSQL, PostgreSQL 7.4.5
  • PostgreSQL, PostgreSQL 7.4.6
  • PostgreSQL, PostgreSQL 7.4.7
  • PostgreSQL, PostgreSQL 7.4.8
  • PostgreSQL, PostgreSQL 7.4.9
  • PostgreSQL, PostgreSQL 8.0
  • PostgreSQL, PostgreSQL 8.0.1
  • PostgreSQL, PostgreSQL 8.0.10
  • PostgreSQL, PostgreSQL 8.0.2
  • PostgreSQL, PostgreSQL 8.0.3
  • PostgreSQL, PostgreSQL 8.0.4
  • PostgreSQL, PostgreSQL 8.0.5
  • PostgreSQL, PostgreSQL 8.0.6
  • PostgreSQL, PostgreSQL 8.0.7
  • PostgreSQL, PostgreSQL 8.0.8
  • PostgreSQL, PostgreSQL 8.0.9
  • PostgreSQL, PostgreSQL 8.1
  • PostgreSQL, PostgreSQL 8.1.1
  • PostgreSQL, PostgreSQL 8.1.2
  • PostgreSQL, PostgreSQL 8.1.3
  • PostgreSQL, PostgreSQL 8.1.4
  • PostgreSQL, PostgreSQL 8.1.5
  • PostgreSQL, PostgreSQL 8.1.6
  • PostgreSQL, PostgreSQL 8.2
  • PostgreSQL, PostgreSQL 8.2.1
  • RedHat, Application Stack v1 for EL AS 4
  • RedHat, Application Stack v1 for EL ES 4
  • RedHat, Enterprise Linux 3 ES
  • RedHat, Enterprise Linux 3 AS
  • RedHat, Enterprise Linux 3 Desktop
  • RedHat, Enterprise Linux 3 WS
  • RedHat, Enterprise Linux 4 WS
  • RedHat, Enterprise Linux 4 AS
  • RedHat, Enterprise Linux 4 Desktop
  • RedHat, Enterprise Linux 4 ES
  • RedHat, Enterprise Linux 5 Client
  • RedHat, Enterprise Linux 5
  • RedHat, Enterprise Linux 5 Client Workstation
  • RedHat, Enterprise Linux 5 Server
  • RedHat, Enterprise Linux Desktop 5.0
  • Sun, Solaris 10 x86
  • Sun, Solaris 10 SPARC

Remedy:

Refer to PostgreSQL News, 2007-04-23 for upgrade information. See References.

For Mandriva Linux (postgresql):
Refer to MDKSA-2007:094 for patch, upgrade, or suggested workaround information. See References.

For Ubuntu Linux:
Refer to USN-454-1 for patch, upgrade, or suggested workaround information. See References.

For Gentoo Linux (postgresql):
Refer to GLSA 200705-12 for patch, upgrade, or suggested workaround information. See References.

For Solaris:
Refer to Sun Alert ID: 102894 for patch, upgrade, or suggested workaround information. See References.

For Red Hat Linux:
Refer to RHSA-2007:0336 for patch, upgrade, or suggested workaround information. See References.

For Debian GNU/Linux (postgresql-8.1):
Refer to DSA-1309-1 for patch, upgrade, or suggested workaround information. See References.

For Debian/GNU Linux:
Refer to DSA-1311-1 for patch, upgrade, or suggested workaround information. See References.

For other distributions:
Contact your vendor for upgrade or patch information.

Consequences:

Gain Privileges

References:

  • PostgreSQL News, 2007-04-23, Security Update Releases at http://www.postgresql.org/about/news.791.
  • PostgreSQL Web site, PostgreSQL: Security Information at http://www.postgresql.org/support/security.
  • Sun Alert ID: 102894, Security Vulnerability in PostgreSQL SECURITY DEFINER Functions May Allow Escalation of Privileges at http://sunsolve.sun.com/search/document.do?assetkey=1-26-102894-1.
  • ASA-2007-172: Security Vulnerability in PostgreSQL SECURITY DEFINER Functions May Allow Escalation of Privileges (Sun 102894)
  • ASA-2007-190: PostgreSQL security update (RHSA-2007-0336 and RHSA-2007-0337)
  • BID-23618: PostgreSQL SECURITY DEFINER Function Local Privilege Escalation Vulnerability
  • CVE-2007-2138: Untrusted search path vulnerability in PostgreSQL before 7.3.19, 7.4.x before 7.4.17, 8.0.x before 8.0.13, 8.1.x before 8.1.9, and 8.2.x before 8.2.4 allows remote authenticated users, when permitted to call a SECURITY DEFINER function, to gain the privileges of the function owner, related to search_path settings.
  • DSA-1309: postgresql-8.1 -- programming error
  • DSA-1311: postgresql-7.4 -- programming error
  • FrSIRT/ADV-2007-1497: PostgreSQL Database SECURITY DEFINER Functions Privilege Escalation Vulnerability
  • FrSIRT/ADV-2007-1549: Sun Solaris PostgreSQL SECURITY DEFINER Functions Privilege Escalation Vulnerability
  • GLSA-200705-12: PostgreSQL: Privilege escalation
  • MDKSA-2007:094: Updated postgresql packages fix vulnerability
  • RHSA-2007-0336: Moderate: postgresql security update
  • RHSA-2007-0337: Moderate: postgresql security update
  • SA25019: PostgreSQL SECURITY DEFINER Functions Privilege Escalation
  • SA25037: Sun Solaris PostgreSQL SECURITY DEFINER Privilege Escalation
  • SA25334: Avaya Products PostgreSQL SECURITY DEFINER Privilege Escalation
  • SECTRACK ID: 1017974: PostgreSQL Lets Remote Authenticated Users Gain Elevated SQL Privileges
  • USN-454-1: PostgreSQL vulnerability

Reported:

Apr 23, 2007

The information within this database may change without notice. Use of this information constitutes acceptance for use in an AS IS condition. There are NO warranties, implied or otherwise, with regard to this information or its use. Any use of this information is at the user's risk. In no event shall the author/distributor (Internet Security Systems X-Force) be held liable for any damages whatsoever arising out of or in connection with the use or spread of this information.

Copyright (c) 1994-2008 Internet Security Systems, Inc. All rights reserved worldwide.

For corrections or additions please email xforce@iss.net

Return to the main page