Skip to content
Fencer Intel
medium 6.5

CVE-2012-0866 json

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 t…

published 2012-07-18 14 y ago modified 2026-06-16 4 mo ago also EUVD-2012-0891

cvss
6.5
version 2.0, NVD
cisa kev
Not listed
not in CISA's catalog
epss
3.6%
EPSS 3.6% chance of exploitation in 30 days, percentile 89%
public exploits
0
none known

Summary

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.

Patch / fix

  • postgresql RHEL 6 8.4.11-1.el6_2
  • postgresql84 RHEL 5 8.4.11-1.el5_8
  • postgresql-libs RHEL 6 8.4.11-1.el6_2
  • postgresql-test RHEL 6 8.4.11-1.el6_2
  • postgresql-pltcl RHEL 6 8.4.11-1.el6_2
  • postgresql84-tcl RHEL 5 8.4.11-1.el5_8
  • postgresql-plperl RHEL 6 8.4.11-1.el6_2
  • postgresql-server RHEL 6 8.4.11-1.el6_2

red hat advisories RHSA-2012:0678RHSA-2012:0677

  • postgresql94 openSUSE Tumbleweed 9.4.10-1.1
  • postgresql93 openSUSE Tumbleweed 9.3.15-1.1
  • postgresql95 openSUSE Tumbleweed 9.5.4-1.2

opensuse advisories openSUSE-SU-2024:10030-1openSUSE-SU-2024:10256-1openSUSE-SU-2024:10273-1

Vendor advisories

What the vendors themselves say about their products: affected, fixed or not affected, and what to do.

red hat product security vex CVE-2012-0866 updated cvss 5.2

postgresql: Absent permission checks on trigger function to be called when creating a trigger

  • Red Hat Enterprise Linux 4 postgresql
    affected: no fix planned “Will not fix”
  • Red Hat Enterprise Linux (v. 5 server) postgresql 8.1.23-4.el5_8, postgresql84 8.4.11-1.el5_8, postgresql-pl 8.1.23-4.el5_8, postgresql-tcl 8.1.23-4.el5_8, postgresql-libs 8.1.23-4.el5_8, postgresql-test 8.1.23-4.el5_8, +12 more Red Hat Enterprise Linux Desktop (v. 5 client) postgresql 8.1.23-4.el5_8, postgresql84 8.4.11-1.el5_8, postgresql-tcl 8.1.23-4.el5_8, postgresql-libs 8.1.23-4.el5_8, postgresql84-tcl 8.4.11-1.el5_8, postgresql-python 8.1.23-4.el5_8, +4 more
    fixed: vendor fix RHSA-2012:0677
  • Red Hat Enterprise Linux Desktop (v. 6) postgresql 8.4.11-1.el6_2, postgresql-libs 8.4.11-1.el6_2 Red Hat Enterprise Linux Desktop Optional (v. 6) postgresql 8.4.11-1.el6_2, postgresql-test 8.4.11-1.el6_2, postgresql-pltcl 8.4.11-1.el6_2, postgresql-plperl 8.4.11-1.el6_2, postgresql-server 8.4.11-1.el6_2, postgresql-contrib 8.4.11-1.el6_2, +1 more Red Hat Enterprise Linux HPC Node (v. 6) postgresql 8.4.11-1.el6_2, postgresql-libs 8.4.11-1.el6_2 Red Hat Enterprise Linux HPC Node Optional (v. 6) postgresql 8.4.11-1.el6_2, postgresql-test 8.4.11-1.el6_2, postgresql-pltcl 8.4.11-1.el6_2, postgresql-plperl 8.4.11-1.el6_2, postgresql-server 8.4.11-1.el6_2, postgresql-contrib 8.4.11-1.el6_2, +1 more Red Hat Enterprise Linux Server (v. 6) postgresql 8.4.11-1.el6_2, postgresql-libs 8.4.11-1.el6_2, postgresql-test 8.4.11-1.el6_2, postgresql-pltcl 8.4.11-1.el6_2, postgresql-plperl 8.4.11-1.el6_2, postgresql-server 8.4.11-1.el6_2, +2 more Red Hat Enterprise Linux Workstation (v. 6) postgresql 8.4.11-1.el6_2, postgresql-libs 8.4.11-1.el6_2, postgresql-test 8.4.11-1.el6_2, postgresql-pltcl 8.4.11-1.el6_2, postgresql-plperl 8.4.11-1.el6_2, postgresql-server 8.4.11-1.el6_2, +2 more
    fixed: vendor fix RHSA-2012:0678
  • Red Hat RHEL Desktop Workstation (v. 5 client) postgresql 8.1.23-4.el5_8, postgresql84 8.4.11-1.el5_8, postgresql-pl 8.1.23-4.el5_8, postgresql-test 8.1.23-4.el5_8, postgresql-server 8.1.23-4.el5_8, postgresql84-test 8.4.11-1.el5_8, +4 more
    fixed: vendor fix RHSA-2012:0677

Red Hat CSAF VEX © Red Hat, Inc., from https://security.access.redhat.com/data/csaf/v2/vex/; changed: reduced to product statuses and remediations. CC BY 4.0 · csaf

Exploit prediction

3.62% chance of exploitation in the next 30 days, higher than 89% of all scored CVEs (FIRST EPSS, 2026-11-09).

CVSS scores

assigned by version score vector
NVD 2.0 6.5 AV:N/AC:L/Au:S/C:P/I:P/A:P

Classification

Weakness
  • CWE-264 Permissions, Privileges, and Access Controls
Technology feeds

References

Sources

Fencer Intel keeps one entry per vulnerability: the CVE id wins, then GHSA, and records that alias each other are merged, except that two CVEs always keep separate entries. The same data is available as JSON.