Read the docs
TI-2012-00801 Aliases CVE-2012-0866GHSA-8fvr-fgp7-p77m

CREATE TRIGGER in PostgreSQL 8.3.x before 8.3.18, 8.4.x before 8.4.11, 9.0.x before…

Priority LOW 35CWE-264Published · Updated

Key facts

Attack vector
Network
Privileges required
Low
User interaction
— Not recorded in CVSS 2.0
Attack complexity
Low
Impact type
Security bypass
Confidentiality · integrity · availability
Partial · Partial · Partial
Fix status
Partial Red Hat: 9 fixed, 1 without a fix

Attack profile from CVSS 2.0 · NVD. Fix status from CNA and Red Hat. Impact type from CWE-264.

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.

Why it matters now

EPSS 0.03625 89th percentileScored 2026-11-07
Fix Partial Red Hat: 2 advisoriesRed Hat: 9 fixed, 1 without a fix

SSVC decision points

Not available: CISA has not published SSVC decision points for this record.

Affected products

VendorProductAffected versionsFixed inStatusSource
——all versions—No fix listedCNA
  • — Vendor— Affected all versions Fixed in — No fix listed CNA

CPE configurations NVD · 39

CPEVersionsRoleVendor
cpe:2.3:a:postgresql:postgresql:8.3:*:*:*:*:*:*:*8.3VulnerablePostgreSQL
cpe:2.3:a:postgresql:postgresql:8.3.1:*:*:*:*:*:*:*8.3.1VulnerablePostgreSQL
cpe:2.3:a:postgresql:postgresql:8.3.2:*:*:*:*:*:*:*8.3.2VulnerablePostgreSQL
cpe:2.3:a:postgresql:postgresql:8.3.3:*:*:*:*:*:*:*8.3.3VulnerablePostgreSQL
cpe:2.3:a:postgresql:postgresql:8.3.4:*:*:*:*:*:*:*8.3.4VulnerablePostgreSQL
cpe:2.3:a:postgresql:postgresql:8.3.5:*:*:*:*:*:*:*8.3.5VulnerablePostgreSQL
cpe:2.3:a:postgresql:postgresql:8.3.6:*:*:*:*:*:*:*8.3.6VulnerablePostgreSQL
cpe:2.3:a:postgresql:postgresql:8.3.7:*:*:*:*:*:*:*8.3.7VulnerablePostgreSQL
cpe:2.3:a:postgresql:postgresql:8.3.8:*:*:*:*:*:*:*8.3.8VulnerablePostgreSQL
cpe:2.3:a:postgresql:postgresql:8.3.9:*:*:*:*:*:*:*8.3.9VulnerablePostgreSQL
  • cpe:2.3:a:postgresql:postgresql:8.3:*:*:*:*:*:*:* Versions 8.3 Vulnerable ·PostgreSQL
  • cpe:2.3:a:postgresql:postgresql:8.3.1:*:*:*:*:*:*:* Versions 8.3.1 Vulnerable ·PostgreSQL
  • cpe:2.3:a:postgresql:postgresql:8.3.2:*:*:*:*:*:*:* Versions 8.3.2 Vulnerable ·PostgreSQL
  • cpe:2.3:a:postgresql:postgresql:8.3.3:*:*:*:*:*:*:* Versions 8.3.3 Vulnerable ·PostgreSQL
  • cpe:2.3:a:postgresql:postgresql:8.3.4:*:*:*:*:*:*:* Versions 8.3.4 Vulnerable ·PostgreSQL
  • cpe:2.3:a:postgresql:postgresql:8.3.5:*:*:*:*:*:*:* Versions 8.3.5 Vulnerable ·PostgreSQL
  • cpe:2.3:a:postgresql:postgresql:8.3.6:*:*:*:*:*:*:* Versions 8.3.6 Vulnerable ·PostgreSQL
  • cpe:2.3:a:postgresql:postgresql:8.3.7:*:*:*:*:*:*:* Versions 8.3.7 Vulnerable ·PostgreSQL
  • cpe:2.3:a:postgresql:postgresql:8.3.8:*:*:*:*:*:*:* Versions 8.3.8 Vulnerable ·PostgreSQL
  • cpe:2.3:a:postgresql:postgresql:8.3.9:*:*:*:*:*:*:* Versions 8.3.9 Vulnerable ·PostgreSQL
Show 29 more CPE
CPEVersionsRoleVendor
cpe:2.3:a:postgresql:postgresql:8.3.10:*:*:*:*:*:*:*8.3.10VulnerablePostgreSQL
cpe:2.3:a:postgresql:postgresql:8.3.11:*:*:*:*:*:*:*8.3.11VulnerablePostgreSQL
cpe:2.3:a:postgresql:postgresql:8.3.12:*:*:*:*:*:*:*8.3.12VulnerablePostgreSQL
cpe:2.3:a:postgresql:postgresql:8.3.13:*:*:*:*:*:*:*8.3.13VulnerablePostgreSQL
cpe:2.3:a:postgresql:postgresql:8.3.14:*:*:*:*:*:*:*8.3.14VulnerablePostgreSQL
cpe:2.3:a:postgresql:postgresql:8.3.15:*:*:*:*:*:*:*8.3.15VulnerablePostgreSQL
cpe:2.3:a:postgresql:postgresql:8.3.16:*:*:*:*:*:*:*8.3.16VulnerablePostgreSQL
cpe:2.3:a:postgresql:postgresql:8.3.17:*:*:*:*:*:*:*8.3.17VulnerablePostgreSQL
cpe:2.3:a:postgresql:postgresql:8.4:*:*:*:*:*:*:*8.4VulnerablePostgreSQL
cpe:2.3:a:postgresql:postgresql:8.4.1:*:*:*:*:*:*:*8.4.1VulnerablePostgreSQL
cpe:2.3:a:postgresql:postgresql:8.4.2:*:*:*:*:*:*:*8.4.2VulnerablePostgreSQL
cpe:2.3:a:postgresql:postgresql:8.4.3:*:*:*:*:*:*:*8.4.3VulnerablePostgreSQL
cpe:2.3:a:postgresql:postgresql:8.4.4:*:*:*:*:*:*:*8.4.4VulnerablePostgreSQL
cpe:2.3:a:postgresql:postgresql:8.4.5:*:*:*:*:*:*:*8.4.5VulnerablePostgreSQL
cpe:2.3:a:postgresql:postgresql:8.4.6:*:*:*:*:*:*:*8.4.6VulnerablePostgreSQL
cpe:2.3:a:postgresql:postgresql:8.4.7:*:*:*:*:*:*:*8.4.7VulnerablePostgreSQL
cpe:2.3:a:postgresql:postgresql:8.4.8:*:*:*:*:*:*:*8.4.8VulnerablePostgreSQL
cpe:2.3:a:postgresql:postgresql:8.4.9:*:*:*:*:*:*:*8.4.9VulnerablePostgreSQL
cpe:2.3:a:postgresql:postgresql:8.4.10:*:*:*:*:*:*:*8.4.10VulnerablePostgreSQL
cpe:2.3:a:postgresql:postgresql:9.0:*:*:*:*:*:*:*9.0VulnerablePostgreSQL
cpe:2.3:a:postgresql:postgresql:9.0.1:*:*:*:*:*:*:*9.0.1VulnerablePostgreSQL
cpe:2.3:a:postgresql:postgresql:9.0.2:*:*:*:*:*:*:*9.0.2VulnerablePostgreSQL
cpe:2.3:a:postgresql:postgresql:9.0.3:*:*:*:*:*:*:*9.0.3VulnerablePostgreSQL
cpe:2.3:a:postgresql:postgresql:9.0.4:*:*:*:*:*:*:*9.0.4VulnerablePostgreSQL
cpe:2.3:a:postgresql:postgresql:9.0.5:*:*:*:*:*:*:*9.0.5VulnerablePostgreSQL
cpe:2.3:a:postgresql:postgresql:9.0.6:*:*:*:*:*:*:*9.0.6VulnerablePostgreSQL
cpe:2.3:a:postgresql:postgresql:9.1:*:*:*:*:*:*:*9.1VulnerablePostgreSQL
cpe:2.3:a:postgresql:postgresql:9.1.1:*:*:*:*:*:*:*9.1.1VulnerablePostgreSQL
cpe:2.3:a:postgresql:postgresql:9.1.2:*:*:*:*:*:*:*9.1.2VulnerablePostgreSQL
  • cpe:2.3:a:postgresql:postgresql:8.3.10:*:*:*:*:*:*:* Versions 8.3.10 Vulnerable ·PostgreSQL
  • cpe:2.3:a:postgresql:postgresql:8.3.11:*:*:*:*:*:*:* Versions 8.3.11 Vulnerable ·PostgreSQL
  • cpe:2.3:a:postgresql:postgresql:8.3.12:*:*:*:*:*:*:* Versions 8.3.12 Vulnerable ·PostgreSQL
  • cpe:2.3:a:postgresql:postgresql:8.3.13:*:*:*:*:*:*:* Versions 8.3.13 Vulnerable ·PostgreSQL
  • cpe:2.3:a:postgresql:postgresql:8.3.14:*:*:*:*:*:*:* Versions 8.3.14 Vulnerable ·PostgreSQL
  • cpe:2.3:a:postgresql:postgresql:8.3.15:*:*:*:*:*:*:* Versions 8.3.15 Vulnerable ·PostgreSQL
  • cpe:2.3:a:postgresql:postgresql:8.3.16:*:*:*:*:*:*:* Versions 8.3.16 Vulnerable ·PostgreSQL
  • cpe:2.3:a:postgresql:postgresql:8.3.17:*:*:*:*:*:*:* Versions 8.3.17 Vulnerable ·PostgreSQL
  • cpe:2.3:a:postgresql:postgresql:8.4:*:*:*:*:*:*:* Versions 8.4 Vulnerable ·PostgreSQL
  • cpe:2.3:a:postgresql:postgresql:8.4.1:*:*:*:*:*:*:* Versions 8.4.1 Vulnerable ·PostgreSQL
  • cpe:2.3:a:postgresql:postgresql:8.4.2:*:*:*:*:*:*:* Versions 8.4.2 Vulnerable ·PostgreSQL
  • cpe:2.3:a:postgresql:postgresql:8.4.3:*:*:*:*:*:*:* Versions 8.4.3 Vulnerable ·PostgreSQL
  • cpe:2.3:a:postgresql:postgresql:8.4.4:*:*:*:*:*:*:* Versions 8.4.4 Vulnerable ·PostgreSQL
  • cpe:2.3:a:postgresql:postgresql:8.4.5:*:*:*:*:*:*:* Versions 8.4.5 Vulnerable ·PostgreSQL
  • cpe:2.3:a:postgresql:postgresql:8.4.6:*:*:*:*:*:*:* Versions 8.4.6 Vulnerable ·PostgreSQL
  • cpe:2.3:a:postgresql:postgresql:8.4.7:*:*:*:*:*:*:* Versions 8.4.7 Vulnerable ·PostgreSQL
  • cpe:2.3:a:postgresql:postgresql:8.4.8:*:*:*:*:*:*:* Versions 8.4.8 Vulnerable ·PostgreSQL
  • cpe:2.3:a:postgresql:postgresql:8.4.9:*:*:*:*:*:*:* Versions 8.4.9 Vulnerable ·PostgreSQL
  • cpe:2.3:a:postgresql:postgresql:8.4.10:*:*:*:*:*:*:* Versions 8.4.10 Vulnerable ·PostgreSQL
  • cpe:2.3:a:postgresql:postgresql:9.0:*:*:*:*:*:*:* Versions 9.0 Vulnerable ·PostgreSQL
  • cpe:2.3:a:postgresql:postgresql:9.0.1:*:*:*:*:*:*:* Versions 9.0.1 Vulnerable ·PostgreSQL
  • cpe:2.3:a:postgresql:postgresql:9.0.2:*:*:*:*:*:*:* Versions 9.0.2 Vulnerable ·PostgreSQL
  • cpe:2.3:a:postgresql:postgresql:9.0.3:*:*:*:*:*:*:* Versions 9.0.3 Vulnerable ·PostgreSQL
  • cpe:2.3:a:postgresql:postgresql:9.0.4:*:*:*:*:*:*:* Versions 9.0.4 Vulnerable ·PostgreSQL
  • cpe:2.3:a:postgresql:postgresql:9.0.5:*:*:*:*:*:*:* Versions 9.0.5 Vulnerable ·PostgreSQL
  • cpe:2.3:a:postgresql:postgresql:9.0.6:*:*:*:*:*:*:* Versions 9.0.6 Vulnerable ·PostgreSQL
  • cpe:2.3:a:postgresql:postgresql:9.1:*:*:*:*:*:*:* Versions 9.1 Vulnerable ·PostgreSQL
  • cpe:2.3:a:postgresql:postgresql:9.1.1:*:*:*:*:*:*:* Versions 9.1.1 Vulnerable ·PostgreSQL
  • cpe:2.3:a:postgresql:postgresql:9.1.2:*:*:*:*:*:*:* Versions 9.1.2 Vulnerable ·PostgreSQL

Remediation

Red Hat 2 advisories

  • RHSA-2012:0678 Released 2012-05-21 · Red Hat rating Moderate
    postgresql and postgresql84 security update
    • RHEL Desktop Workstation (v. 5 client) postgresql84-8.4.11-1.el5_8, postgresql84-devel-8.4.11-1.el5_8, postgresql84-devel-8.4.11-1.el5_8.i386 +10
    • Red Hat Enterprise Linux (v. 5 server) postgresql84-8.4.11-1.el5_8, postgresql84-8.4.11-1.el5_8.i386, postgresql84-8.4.11-1.el5_8.ia64 +45
    • Red Hat Enterprise Linux Desktop (v. 5 client) postgresql84-8.4.11-1.el5_8, postgresql84-8.4.11-1.el5_8.i386, postgresql84-contrib-8.4.11-1.el5_8 +9
    • 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-contrib-8.4.11-1.el6_2, postgresql-devel-8.4.11-1.el6_2 +6
    • 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-contrib-8.4.11-1.el6_2, postgresql-devel-8.4.11-1.el6_2 +6
    • Red Hat Enterprise Linux Server (v. 6) postgresql-8.4.11-1.el6_2, postgresql-8.4.11-1.el6_2.ppc, postgresql-contrib-8.4.11-1.el6_2 +10
    • Red Hat Enterprise Linux Workstation (v. 6) postgresql-8.4.11-1.el6_2, postgresql-contrib-8.4.11-1.el6_2, postgresql-devel-8.4.11-1.el6_2 +7
  • RHSA-2012:0677 Released 2012-05-21 · Red Hat rating Moderate
    postgresql security update
    • RHEL Desktop Workstation (v. 5 client) postgresql-8.1.23-4.el5_8, postgresql-devel-8.1.23-4.el5_8, postgresql-devel-8.1.23-4.el5_8.i386 +6
    • Red Hat Enterprise Linux (v. 5 server) postgresql-8.1.23-4.el5_8, postgresql-8.1.23-4.el5_8.i386, postgresql-8.1.23-4.el5_8.ia64 +37
    • Red Hat Enterprise Linux Desktop (v. 5 client) postgresql-8.1.23-4.el5_8, postgresql-8.1.23-4.el5_8.i386, postgresql-contrib-8.1.23-4.el5_8 +9

Vendor assessments

Red Hat

Red Hat rating: Low. Red Hat's page for this CVE →

ProductStatusPlan or fix
Red Hat Enterprise Linux 4AffectedNo fix planned: Will not fix
RHEL Desktop Workstation (v. 5 client)Fixed RHSA-2012:0677, RHSA-2012:0678
Red Hat Enterprise Linux (v. 5 server)Fixed RHSA-2012:0677, RHSA-2012:0678
Red Hat Enterprise Linux Desktop (v. 5 client)Fixed RHSA-2012:0677, RHSA-2012:0678
Red Hat Enterprise Linux Desktop (v. 6)Fixed RHSA-2012:0678
Red Hat Enterprise Linux Desktop Optional (v. 6)Fixed RHSA-2012:0678
Red Hat Enterprise Linux HPC Node (v. 6)Fixed RHSA-2012:0678
Red Hat Enterprise Linux HPC Node Optional (v. 6)Fixed RHSA-2012:0678
Red Hat Enterprise Linux Server (v. 6)Fixed RHSA-2012:0678
Red Hat Enterprise Linux Workstation (v. 6)Fixed RHSA-2012:0678

Timeline

  1. 2026-10-02 Threatist record created from CVE-2012-0866
  2. 2026-10-03 Alias added: GHSA-8fvr-fgp7-p77m

References

Advisory 8

Other 5

  • TI-2019-06651 In PostgreSQL 9.3 through 11.2, the "COPY TO/FROM PROGRAM" function allows superusers and… CVSS 3.0HIGH 7.2
  • TI-2017-05187 Improper authentication in postgresql CVSS 3.0CRITICAL 9.8
  • TI-2020-15711 SQL injection in postgresql CVSS 3.1HIGH 8.8
  • TI-2013-01675 Argument injection vulnerability in PostgreSQL 9.2.x before 9.2.4, 9.1.x before 9.1.9… CVSS 2.0MEDIUM 6.5
  • TI-2007-03176 The Database Link library (dblink) in PostgreSQL 8.1 implements functions via CREATE… CVSS 2.0HIGH 9.0
  • TI-2022-01423 SQL injection in postgresql CVSS 3.1HIGH 8.8
See all 202 →

Sources

This product uses the NVD API but is not endorsed or certified by the NVD. Sources and licences