Upstream information

CVE-2012-0866 at MITRE

Description

CREATE TRIGGER in PostgreSQL 8.3.x before 8.3.18, 8.4.x before 8.4.11, 9.0.x before 9.0.7, and 9.1.x before 9.1.3 does not properly check the execute permission for trigger functions marked SECURITY DEFINER, which allows remote authenticated users to execute otherwise restricted triggers on arbitrary data by installing the trigger on an attacker-owned table.

SUSE information

Overall state of this security issue: Resolved

This issue is currently rated as having moderate severity.

CVSS v2 Scores
  National Vulnerability Database
Base Score 6.5
Vector AV:N/AC:L/Au:S/C:P/I:P/A:P
Access Vector Network
Access Complexity Low
Authentication Single
Confidentiality Impact Partial
Integrity Impact Partial
Availability Impact Partial
SUSE Bugzilla entries: 701489 [RESOLVED / FIXED], 749299 [RESOLVED / FIXED], 749301 [RESOLVED / FIXED], 749303 [RESOLVED / FIXED]

SUSE Security Advisories:

List of released packages

Product(s) Fixed package version(s) References
SUSE Linux Enterprise Desktop 12
  • libecpg6 >= 9.3.5-2.3
  • libpq5 >= 9.3.5-2.3
  • libpq5-32bit >= 9.3.5-2.3
  • postgresql93 >= 9.3.5-2.24
Patchnames:
SUSE Linux Enterprise Desktop 12 GA libecpg6
SUSE Linux Enterprise Desktop 12 SP1
  • libecpg6 >= 9.4.5-4.1
  • libpq5 >= 9.4.5-4.1
  • libpq5-32bit >= 9.4.5-4.1
  • postgresql94 >= 9.4.5-4.5
Patchnames:
SUSE Linux Enterprise Desktop 12 SP1 GA libecpg6
SUSE Linux Enterprise Desktop 12 SP2
  • libecpg6 >= 9.4.9-14.1
  • libpq5 >= 9.4.9-14.1
  • libpq5-32bit >= 9.4.9-14.1
  • postgresql94 >= 9.4.9-14.1
Patchnames:
SUSE Linux Enterprise Desktop 12 SP2 GA libecpg6
SUSE Linux Enterprise Desktop 12 SP3
  • libecpg6 >= 9.6.3-2.1
  • libpq5 >= 9.6.3-2.1
  • libpq5-32bit >= 9.6.3-2.1
  • postgresql96 >= 9.6.3-2.4
Patchnames:
SUSE Linux Enterprise Desktop 12 SP3 GA libecpg6
SUSE Linux Enterprise Server 11 SP1
  • postgresql >= 8.3.18-0.3.1
  • postgresql-contrib >= 8.3.18-0.3.1
  • postgresql-docs >= 8.3.18-0.3.1
  • postgresql-init >= 9.1-0.6.10.1
  • postgresql-libs >= 8.3.18-0.3.1
  • postgresql-libs-32bit >= 8.3.18-0.3.1
  • postgresql-libs-x86 >= 8.3.18-0.3.1
  • postgresql-server >= 8.3.18-0.3.1
Patchnames:
slessp1-postgresql
SUSE Linux Enterprise Server 11 SP2
  • postgresql >= 8.3.18-0.3.1
  • postgresql-contrib >= 8.3.18-0.3.1
  • postgresql-docs >= 8.3.18-0.3.1
  • postgresql-init >= 9.1-0.6.10.1
  • postgresql-libs >= 8.3.18-0.3.1
  • postgresql-libs-32bit >= 8.3.18-0.3.1
  • postgresql-libs-x86 >= 8.3.18-0.3.1
  • postgresql-server >= 8.3.18-0.3.1
Patchnames:
slessp1-postgresql
SUSE Linux Enterprise Server 11 SP3
  • postgresql >= 8.3.23-0.4.1
  • postgresql-contrib >= 8.3.23-0.4.1
  • postgresql-docs >= 8.3.23-0.4.1
  • postgresql-server >= 8.3.23-0.4.1
Patchnames:
SUSE Linux Enterprise Server 11 SP3 GA postgresql
SUSE Linux Enterprise Server 11 SP4
  • libecpg6 >= 9.4.4-0.6.2
  • libpq5 >= 9.4.4-0.6.2
  • libpq5-32bit >= 9.4.4-0.6.2
  • postgresql >= 8.3.23-0.4.1
  • postgresql-contrib >= 8.3.23-0.4.1
  • postgresql-docs >= 8.3.23-0.4.1
  • postgresql-server >= 8.3.23-0.4.1
  • postgresql94 >= 9.4.4-0.6.2
  • postgresql94-contrib >= 9.4.4-0.6.2
  • postgresql94-docs >= 9.4.4-0.6.2
  • postgresql94-server >= 9.4.4-0.6.2
Patchnames:
SUSE Linux Enterprise Server 11 SP4 GA libecpg6
SUSE Linux Enterprise Server 11 SP4 GA postgresql
SUSE Linux Enterprise Server 12
  • libecpg6 >= 9.3.5-2.3
  • libpq5 >= 9.3.5-2.3
  • libpq5-32bit >= 9.3.5-2.3
  • postgresql93 >= 9.3.5-2.24
  • postgresql93-contrib >= 9.3.5-2.24
  • postgresql93-docs >= 9.3.5-2.24
  • postgresql93-server >= 9.3.5-2.24
Patchnames:
SUSE Linux Enterprise Server 12 GA libecpg6
SUSE Linux Enterprise Server 12 SP1
  • libecpg6 >= 9.4.5-4.1
  • libpq5 >= 9.4.5-4.1
  • libpq5-32bit >= 9.4.5-4.1
  • postgresql94 >= 9.4.5-4.5
  • postgresql94-contrib >= 9.4.5-4.5
  • postgresql94-docs >= 9.4.5-4.5
  • postgresql94-server >= 9.4.5-4.5
Patchnames:
SUSE Linux Enterprise Server 12 SP1 GA libecpg6
SUSE Linux Enterprise Server 12 SP2
  • libecpg6 >= 9.4.9-14.1
  • libpq5 >= 9.4.9-14.1
  • libpq5-32bit >= 9.4.9-14.1
  • postgresql94 >= 9.4.9-14.1
  • postgresql94-contrib >= 9.4.9-14.1
  • postgresql94-docs >= 9.4.9-14.1
  • postgresql94-server >= 9.4.9-14.1
Patchnames:
SUSE Linux Enterprise Server 12 SP2 GA libecpg6
SUSE Linux Enterprise Server 12 SP3
  • libecpg6 >= 9.6.3-2.1
  • libpq5 >= 9.6.3-2.1
  • libpq5-32bit >= 9.6.3-2.1
  • postgresql96 >= 9.6.3-2.4
  • postgresql96-contrib >= 9.6.3-2.4
  • postgresql96-docs >= 9.6.3-2.4
  • postgresql96-server >= 9.6.3-2.4
Patchnames:
SUSE Linux Enterprise Server 12 SP3 GA libecpg6
SUSE Linux Enterprise Server for Raspberry Pi 12 SP2
  • libecpg6 >= 9.4.9-14.1
  • libpq5 >= 9.4.9-14.1
  • postgresql94 >= 9.4.9-14.1
  • postgresql94-contrib >= 9.4.9-14.1
  • postgresql94-docs >= 9.4.9-14.1
  • postgresql94-server >= 9.4.9-14.1
Patchnames:
SUSE Linux Enterprise Server for Raspberry Pi 12 SP2 GA libecpg6
SUSE Linux Enterprise Software Development Kit 11 SP4
  • postgresql-devel >= 8.3.23-0.4.1
  • postgresql94-devel >= 9.4.4-0.6.2
Patchnames:
SUSE Linux Enterprise Software Development Kit 11 SP4 GA postgresql-devel
SUSE Linux Enterprise Software Development Kit 11 SP4 GA postgresql94-devel
SUSE Linux Enterprise Software Development Kit 12
  • postgresql93-devel >= 9.3.5-2.3
Patchnames:
SUSE Linux Enterprise Software Development Kit 12 GA postgresql93-devel
SUSE Linux Enterprise Software Development Kit 12 SP1
  • postgresql94-devel >= 9.4.5-4.1
Patchnames:
SUSE Linux Enterprise Software Development Kit 12 SP1 GA postgresql94-devel
SUSE Linux Enterprise Software Development Kit 12 SP2
  • postgresql94-devel >= 9.4.9-14.1
Patchnames:
SUSE Linux Enterprise Software Development Kit 12 SP2 GA postgresql94-devel
SUSE Linux Enterprise Software Development Kit 12 SP3
  • postgresql96-devel >= 9.6.3-2.1
Patchnames:
SUSE Linux Enterprise Software Development Kit 12 SP3 GA postgresql96-devel
SUSE Linux Enterprise Software Development Kit 11 SP1
SUSE Linux Enterprise Software Development Kit 11 SP2
  • postgresql-devel >= 8.3.18-0.3.1
Builds
SAT Patch Nr: 6023
SUSE Linux Enterprise Desktop 11 SP1
SUSE Linux Enterprise Desktop 11 SP2
  • postgresql >= 8.3.18-0.3.1
  • postgresql-libs >= 8.3.18-0.3.1
Builds
SAT Patch Nr: 6023
SUSE Linux Enterprise Desktop 11 SP1
SUSE Linux Enterprise Desktop 11 SP2
  • postgresql >= 8.3.18-0.3.1
  • postgresql-libs >= 8.3.18-0.3.1
  • postgresql-libs-32bit >= 8.3.18-0.3.1
Builds
SAT Patch Nr: 6023
SUSE Linux Enterprise Server 11 SP1
SUSE Linux Enterprise Server 11 SP1 for VMware
SUSE Linux Enterprise Server 11 SP2
  • postgresql >= 8.3.18-0.3.1
  • postgresql-contrib >= 8.3.18-0.3.1
  • postgresql-docs >= 8.3.18-0.3.1
  • postgresql-libs >= 8.3.18-0.3.1
  • postgresql-libs-32bit >= 8.3.18-0.3.1
  • postgresql-server >= 8.3.18-0.3.1
Builds
SAT Patch Nr: 6023
SUSE Linux Enterprise Server 11 SP1
SUSE Linux Enterprise Server 11 SP1 for VMware
SUSE Linux Enterprise Server 11 SP2
  • postgresql >= 8.3.18-0.3.1
  • postgresql-contrib >= 8.3.18-0.3.1
  • postgresql-docs >= 8.3.18-0.3.1
  • postgresql-libs >= 8.3.18-0.3.1
  • postgresql-server >= 8.3.18-0.3.1
Builds
SAT Patch Nr: 6023
SUSE Linux Enterprise Server 11 SP1
SUSE Linux Enterprise Server 11 SP2
  • postgresql >= 8.3.18-0.3.1
  • postgresql-contrib >= 8.3.18-0.3.1
  • postgresql-docs >= 8.3.18-0.3.1
  • postgresql-libs >= 8.3.18-0.3.1
  • postgresql-libs-x86 >= 8.3.18-0.3.1
  • postgresql-server >= 8.3.18-0.3.1
Builds
SAT Patch Nr: 6023
SUSE Linux Enterprise Desktop 10 SP4 for x86
  • postgresql-devel >= 8.1.22-0.8.1
  • postgresql-libs >= 8.1.22-0.8.1
Builds
ZYPP Patch Nr: 8071
SUSE Linux Enterprise Desktop 10 SP4 for AMD64 and Intel EM64T
  • postgresql-devel >= 8.1.22-0.8.1
  • postgresql-libs >= 8.1.22-0.8.1
  • postgresql-libs-32bit >= 8.1.22-0.8.1
Builds
ZYPP Patch Nr: 8071
SLE SDK 10 SP4 for IBM iSeries and IBM pSeries
SLE SDK 10 SP4 for IBM zSeries
SLE SDK 10 SP4 for IPF
SLE SDK 10 SP4 for X86-64
SLE SDK 10 SP4 for x86
  • postgresql >= 8.1.22-0.8.1
  • postgresql-contrib >= 8.1.22-0.8.1
  • postgresql-devel >= 8.1.22-0.8.1
  • postgresql-docs >= 8.1.22-0.8.1
  • postgresql-server >= 8.1.22-0.8.1
Builds
ZYPP Patch Nr: 8071
SUSE Linux Enterprise Server 10 SP4 for x86
  • postgresql >= 8.1.22-0.8.1
  • postgresql-contrib >= 8.1.22-0.8.1
  • postgresql-devel >= 8.1.22-0.8.1
  • postgresql-docs >= 8.1.22-0.8.1
  • postgresql-libs >= 8.1.22-0.8.1
  • postgresql-server >= 8.1.22-0.8.1
Builds
ZYPP Patch Nr: 8071
SUSE Linux Enterprise Server 10 SP4 for IPF
  • postgresql >= 8.1.22-0.8.1
  • postgresql-contrib >= 8.1.22-0.8.1
  • postgresql-devel >= 8.1.22-0.8.1
  • postgresql-docs >= 8.1.22-0.8.1
  • postgresql-libs >= 8.1.22-0.8.1
  • postgresql-libs-x86 >= 8.1.22-0.8.1
  • postgresql-server >= 8.1.22-0.8.1
Builds
ZYPP Patch Nr: 8071
SUSE Linux Enterprise Server 10 SP4 for IBM POWER
  • postgresql >= 8.1.22-0.8.1
  • postgresql-contrib >= 8.1.22-0.8.1
  • postgresql-devel >= 8.1.22-0.8.1
  • postgresql-docs >= 8.1.22-0.8.1
  • postgresql-libs >= 8.1.22-0.8.1
  • postgresql-libs-64bit >= 8.1.22-0.8.1
  • postgresql-server >= 8.1.22-0.8.1
Builds
ZYPP Patch Nr: 8071
SUSE Linux Enterprise Server 10 SP4 for AMD64 and Intel EM64T
SUSE Linux Enterprise Server 10 SP4 for IBM zSeries 64bit
  • postgresql >= 8.1.22-0.8.1
  • postgresql-contrib >= 8.1.22-0.8.1
  • postgresql-devel >= 8.1.22-0.8.1
  • postgresql-docs >= 8.1.22-0.8.1
  • postgresql-libs >= 8.1.22-0.8.1
  • postgresql-libs-32bit >= 8.1.22-0.8.1
  • postgresql-server >= 8.1.22-0.8.1
Builds
ZYPP Patch Nr: 8071
openSUSE 11.4
  • libecpg6 >= 9.0.7-12.2
  • libecpg6-debuginfo >= 9.0.7-12.2
  • libpq5 >= 9.0.7-12.2
  • libpq5-32bit >= 9.0.7-12.2
  • libpq5-debuginfo >= 9.0.7-12.2
  • libpq5-debuginfo-32bit >= 9.0.7-12.2
  • libpq5-debuginfo-x86 >= 9.0.7-12.2
  • libpq5-x86 >= 9.0.7-12.2
  • postgresql >= 9.0.7-12.1
  • postgresql-contrib >= 9.0.7-12.1
  • postgresql-contrib-debuginfo >= 9.0.7-12.1
  • postgresql-debuginfo >= 9.0.7-12.1
  • postgresql-debugsource >= 9.0.7-12.1
  • postgresql-devel >= 9.0.7-12.2
  • postgresql-devel-debuginfo >= 9.0.7-12.2
  • postgresql-docs >= 9.0.7-12.1
  • postgresql-libs >= 9.0.7-12.2
  • postgresql-libs-debugsource >= 9.0.7-12.2
  • postgresql-plperl >= 9.0.7-12.1
  • postgresql-plperl-debuginfo >= 9.0.7-12.1
  • postgresql-plpython >= 9.0.7-12.1
  • postgresql-plpython-debuginfo >= 9.0.7-12.1
  • postgresql-pltcl >= 9.0.7-12.1
  • postgresql-pltcl-debuginfo >= 9.0.7-12.1
  • postgresql-server >= 9.0.7-12.1
  • postgresql-server-debuginfo >= 9.0.7-12.1
Patchnames:
openSUSE-2012-214
openSUSE Leap 15.0
  • postgresql96 >= 9.6.8-lp150.1.2
  • postgresql96-server >= 9.6.8-lp150.1.2
Patchnames:
openSUSE Leap 15.0 GA postgresql96
openSUSE Leap 42.1
  • libecpg6 >= 9.4.5-1.1
  • libpq5 >= 9.4.5-1.1
  • libpq5-32bit >= 9.4.5-1.1
  • postgresql94 >= 9.4.5-1.2
  • postgresql94-contrib >= 9.4.5-1.2
  • postgresql94-devel >= 9.4.5-1.1
  • postgresql94-docs >= 9.4.5-1.2
  • postgresql94-server >= 9.4.5-1.2
Patchnames:
openSUSE Leap 42.1 GA libecpg6
openSUSE Leap 42.2
  • libecpg6 >= 9.4.9-8.1
  • libpq5 >= 9.4.9-8.1
  • postgresql93-docs >= 9.3.11-4.1
  • postgresql94 >= 9.4.9-8.1
  • postgresql94-contrib >= 9.4.9-8.1
  • postgresql94-devel >= 9.4.9-8.1
  • postgresql94-docs >= 9.4.9-8.1
  • postgresql94-server >= 9.4.9-8.1
Patchnames:
openSUSE Leap 42.2 GA libecpg6
openSUSE Leap 42.2 GA postgresql93-docs
openSUSE Leap 42.3
  • libecpg6 >= 9.6.3-3.1
  • libpq5 >= 9.6.3-3.1
  • postgresql93-docs >= 9.3.17-6.1
  • postgresql94-docs >= 9.4.12-10.1
  • postgresql95-docs >= 9.5.7-1.8
  • postgresql96 >= 9.6.3-3.1
  • postgresql96-contrib >= 9.6.3-3.1
  • postgresql96-devel >= 9.6.3-3.1
  • postgresql96-docs >= 9.6.3-3.1
  • postgresql96-server >= 9.6.3-3.1
Patchnames:
openSUSE Leap 42.3 GA libecpg6
openSUSE Leap 42.3 GA postgresql93-docs
openSUSE Leap 42.3 GA postgresql94-docs
openSUSE Leap 42.3 GA postgresql95-docs
openSUSE Tumbleweed
  • libecpg6 >= 9.5.4-1.2
  • libecpg6-32bit >= 9.5.4-1.2
  • libpq5 >= 9.5.4-1.2
  • libpq5-32bit >= 9.5.4-1.2
  • postgresql93 >= 9.3.15-1.1
  • postgresql93-contrib >= 9.3.15-1.1
  • postgresql93-devel >= 9.3.15-1.1
  • postgresql93-docs >= 9.3.15-1.1
  • postgresql93-plperl >= 9.3.15-1.1
  • postgresql93-plpython >= 9.3.15-1.1
  • postgresql93-pltcl >= 9.3.15-1.1
  • postgresql93-server >= 9.3.15-1.1
  • postgresql93-test >= 9.3.15-1.1
  • postgresql94 >= 9.4.10-1.1
  • postgresql94-contrib >= 9.4.10-1.1
  • postgresql94-devel >= 9.4.10-1.1
  • postgresql94-docs >= 9.4.10-1.1
  • postgresql94-plperl >= 9.4.10-1.1
  • postgresql94-plpython >= 9.4.10-1.1
  • postgresql94-pltcl >= 9.4.10-1.1
  • postgresql94-server >= 9.4.10-1.1
  • postgresql94-test >= 9.4.10-1.1
  • postgresql95 >= 9.5.4-1.2
  • postgresql95-contrib >= 9.5.4-1.2
  • postgresql95-devel >= 9.5.4-1.2
  • postgresql95-docs >= 9.5.4-1.2
  • postgresql95-plperl >= 9.5.4-1.2
  • postgresql95-plpython >= 9.5.4-1.2
  • postgresql95-pltcl >= 9.5.4-1.2
  • postgresql95-server >= 9.5.4-1.2
  • postgresql95-test >= 9.5.4-1.2
Patchnames:
openSUSE Tumbleweed GA libecpg6-32bit
openSUSE Tumbleweed GA postgresql93
openSUSE Tumbleweed GA postgresql94


Status of this issue by product and package

Please note that this evaluation state might be work in progress, incomplete or outdated. Also information for service packs in the LTSS phase is only included for issues meeting the LTSS criteria. If in doubt, feel free to contact us for clarification.

Product(s) Source package State
SUSE Linux Enterprise Desktop 10 SP3 postgresql Released
SUSE Linux Enterprise Desktop 10 SP4 postgresql Released
SUSE Linux Enterprise Desktop 11 SP1 postgresql Released
SUSE Linux Enterprise Server 10 SP3 postgresql Released
SUSE Linux Enterprise Server 10 SP4 postgresql Released
SUSE Linux Enterprise Server 10 SP4 LTSS postgresql Released
SUSE Linux Enterprise Server 11 SP1 postgresql Released
SUSE Linux Enterprise Server 11 SP1 LTSS postgresql Released
SUSE Linux Enterprise Server for SAP AIO 11 SP1 postgresql Released