CVE-2012-0866: 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…
Noroxi assessment
Priority: Monitor (action score 27/100)
- The sources we track (CISA KEV, Exploit-DB, Metasploit, Nuclei, GitHub) show no public exploit code or exploitation in the wild.
- Probability of exploitation in the next 30 days: 3.6% (FIRST EPSS); higher than 89.7% of all records.
- No special conditions are required; it is repeatable.
- Fixed version: postgresql-8.4 (Debian:6.0) 8.4.11-0squeeze1; postgresql93 (openSUSE:Tumbleweed) 9.3.15-1.1; postgresql94 (openSUSE:Tumbleweed) 9.4.10-1.1.
Low priority for now. Upgrade to postgresql-8.4 (Debian:6.0) 8.4.11-0squeeze1; postgresql93 (openSUSE:Tumbleweed) 9.3.15-1.1; postgresql94 (openSUSE:Tumbleweed) 9.4.10-1.1 or later.
Generated automatically from the record's data: CVSS (NVD and CNA), CISA KEV and SSVC, FIRST EPSS, exploit sources, fixed versions. How we calculate it
Primary sources: NVD · CVE.org · FIRST EPSS
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.
- Published
- Jul 18, 2012
- Updated
- Jun 16, 2026
- EPSS
- 3.6% · 89th percentile
- CWE
- CWE-264
Report tools
Action score
27
Low priority for now.
- CVSS
- 26 / 40 · 6.5 / 10
- CISA KEV
- 0 / 30 · Not listed
- EPSS
- 1 / 30 · 3.6%
Get told when this record changes
- Not in KEV: no record of exploitation in the wild
- No public exploit code on record
- A fix has been released
If any of these changes, we'll tell you in the daily email digest.
Is PostgreSQL on your server exposed to the internet?Run a port scan
Is your version affected? Check itNoroxi analysis
What does it mean in your environment?
The assessment above is generated automatically from the record's data; it doesn't know your environment. Our team verifies on your systems whether this vulnerability is actually exploitable and which mitigation is enough.
We use this product, ask for helpAffected systems
Is your version affected?
Pick the product and type the version you run. It's compared with this record's version ranges in your browser; the version isn't sent anywhere.
| Vendor | Product | CPE |
|---|---|---|
| postgresql | postgresql | cpe:2.3:a:postgresql:postgresql |
Using postgresql? Add it to your stack and be the first to know about CVEs like this one. (PostgreSQL)
Is PostgreSQL on your server exposed to the internet?
The free port scanner finds the open ports on your server and matches the service versions it can read against known vulnerabilities. No account needed.
Run a port scanAffected versions
NVD version ranges (for catalog products). Add the product to your stack with a version and matching uses these.
- postgresql postgresql8.3
- postgresql postgresql8.3.1
- postgresql postgresql8.3.10
- postgresql postgresql8.3.11
- postgresql postgresql8.3.12
- postgresql postgresql8.3.13
- postgresql postgresql8.3.14
- postgresql postgresql8.3.15
+12 more rows
- postgresql postgresql8.3.16
- postgresql postgresql8.3.17
- postgresql postgresql8.3.2
- postgresql postgresql8.3.3
- postgresql postgresql8.3.4
- postgresql postgresql8.3.5
- postgresql postgresql8.3.6
- postgresql postgresql8.3.7
- postgresql postgresql8.3.8
- postgresql postgresql8.3.9
- postgresql postgresql8.4
- postgresql postgresql8.4.1
Package-level exposure
OSV and GitHub Advisory data: ecosystem, package and range. SBOM matching uses this table.
| Ecosystem | Package | Affected range | Fix |
|---|---|---|---|
| Debian:6.0 | postgresql-8.4 | before 8.4.11-0squeeze1 | 8.4.11-0squeeze1 |
| openSUSE:Tumbleweed | postgresql93 | before 9.3.15-1.1 | 9.3.15-1.1 |
| openSUSE:Tumbleweed | postgresql94 | before 9.4.10-1.1 | 9.4.10-1.1 |
| openSUSE:Tumbleweed | postgresql95 | before 9.5.4-1.2 | 9.5.4-1.2 |
| Red Hat:enterprise_linux:5::client | postgresql | before 0:8.1.23-4.el5_8 | 0:8.1.23-4.el5_8 |
| Red Hat:enterprise_linux:5::client | postgresql-contrib | before 0:8.1.23-4.el5_8 | 0:8.1.23-4.el5_8 |
| Red Hat:enterprise_linux:5::client | postgresql-debuginfo | before 0:8.1.23-4.el5_8 | 0:8.1.23-4.el5_8 |
| Red Hat:enterprise_linux:5::client | postgresql-docs | before 0:8.1.23-4.el5_8 | 0:8.1.23-4.el5_8 |
| Red Hat:enterprise_linux:5::client | postgresql-libs | before 0:8.1.23-4.el5_8 | 0:8.1.23-4.el5_8 |
| Red Hat:enterprise_linux:5::client | postgresql-python | before 0:8.1.23-4.el5_8 | 0:8.1.23-4.el5_8 |
| Red Hat:enterprise_linux:5::client | postgresql-tcl | before 0:8.1.23-4.el5_8 | 0:8.1.23-4.el5_8 |
| Red Hat:enterprise_linux:5::client | postgresql84 | before 0:8.4.11-1.el5_8 | 0:8.4.11-1.el5_8 |
| Red Hat:enterprise_linux:5::client | postgresql84-contrib | before 0:8.4.11-1.el5_8 | 0:8.4.11-1.el5_8 |
| Red Hat:enterprise_linux:5::client | postgresql84-debuginfo | before 0:8.4.11-1.el5_8 | 0:8.4.11-1.el5_8 |
| Red Hat:enterprise_linux:5::client | postgresql84-docs | before 0:8.4.11-1.el5_8 | 0:8.4.11-1.el5_8 |
| Red Hat:enterprise_linux:5::client | postgresql84-libs | before 0:8.4.11-1.el5_8 | 0:8.4.11-1.el5_8 |
| Red Hat:enterprise_linux:5::client | postgresql84-python | before 0:8.4.11-1.el5_8 | 0:8.4.11-1.el5_8 |
| Red Hat:enterprise_linux:5::client | postgresql84-tcl | before 0:8.4.11-1.el5_8 | 0:8.4.11-1.el5_8 |
| Red Hat:enterprise_linux:5::client_workstation | postgresql-devel | before 0:8.1.23-4.el5_8 | 0:8.1.23-4.el5_8 |
| Red Hat:enterprise_linux:5::client_workstation | postgresql-pl | before 0:8.1.23-4.el5_8 | 0:8.1.23-4.el5_8 |
| Red Hat:enterprise_linux:5::client_workstation | postgresql-server | before 0:8.1.23-4.el5_8 | 0:8.1.23-4.el5_8 |
| Red Hat:enterprise_linux:5::client_workstation | postgresql-test | before 0:8.1.23-4.el5_8 | 0:8.1.23-4.el5_8 |
| Red Hat:enterprise_linux:5::client_workstation | postgresql84-devel | before 0:8.4.11-1.el5_8 | 0:8.4.11-1.el5_8 |
| Red Hat:enterprise_linux:5::client_workstation | postgresql84-plperl | before 0:8.4.11-1.el5_8 | 0:8.4.11-1.el5_8 |
+15
Same product
postgresql: all recordsOther highest-scoring records for the same primary product.
- CVE-2017-7546PostgreSQL versions before 9.2.22, 9.3.18, 9.4.13, 9.5.8 and 9.6.4 are vulnerable to incorrect authentication flaw allowing remote…57Plan
- CVE-2019-9193In PostgreSQL 9.3 through 11.2, the "COPY TO/FROM PROGRAM" function allows superusers and users in the 'pg_execute_server_program' group to…55Plan
- CVE-2020-25695A flaw was found in PostgreSQL versions before 13.1, before 12.5, before 11.10, before 10.15, before 9.6.20 and before 9.5.24.49Plan
Published before and after this one in the same product
- ← EarlierCVE-2010-4015Feb 1, 2011 · Buffer overflow in the gettoken function in contrib/intarray/_int_bool.c in the intarray array module in PostgreSQL 9.0.x before 9.0.3, 8.4.27Monitor
- ← EarlierCVE-2012-2143Jul 5, 2012 · The crypt_des (aka DES-based crypt) function in FreeBSD before 9.0-RELEASE-p2, as used in PHP, PostgreSQL, and other products, does not…19Monitor
- Later →CVE-2012-0867Jul 18, 2012 · PostgreSQL 8.4.x before 8.4.11, 9.0.x before 9.0.7, and 9.1.x before 9.1.3 truncates the common name to only 32 characters when verifying…18Monitor
Remediation
Which version to upgrade to
Fix versions compiled from the vendor, package registries and Microsoft. Verify the vendor's note before upgrading.
| Product / package | Fixed version | Source |
|---|---|---|
| debian:postgresql-8.4 | 8.4.11-0squeeze1 · Debian:6.0 | Package registry (OSV) |
| opensuse:postgresql93 | 9.3.15-1.1 · openSUSE:Tumbleweed | Package registry (OSV) |
| opensuse:postgresql94 | 9.4.10-1.1 · openSUSE:Tumbleweed | Package registry (OSV) |
| opensuse:postgresql95 | 9.5.4-1.2 · openSUSE:Tumbleweed | Package registry (OSV) |
| red hat:postgresql | 0:8.1.23-4.el5_8 · Red Hat:enterprise_linux:5::client | Package registry (OSV) |
| red hat:postgresql-contrib | 0:8.1.23-4.el5_8 · Red Hat:enterprise_linux:5::client | Package registry (OSV) |
| red hat:postgresql-debuginfo | 0:8.1.23-4.el5_8 · Red Hat:enterprise_linux:5::client | Package registry (OSV) |
| red hat:postgresql-devel | 0:8.1.23-4.el5_8 · Red Hat:enterprise_linux:5::client_workstation | Package registry (OSV) |
| red hat:postgresql-docs | 0:8.1.23-4.el5_8 · Red Hat:enterprise_linux:5::client | Package registry (OSV) |
| red hat:postgresql-libs | 0:8.1.23-4.el5_8 · Red Hat:enterprise_linux:5::client | Package registry (OSV) |
| red hat:postgresql-pl | 0:8.1.23-4.el5_8 · Red Hat:enterprise_linux:5::client_workstation | Package registry (OSV) |
| red hat:postgresql-python | 0:8.1.23-4.el5_8 · Red Hat:enterprise_linux:5::client | Package registry (OSV) |
| red hat:postgresql-server | 0:8.1.23-4.el5_8 · Red Hat:enterprise_linux:5::client_workstation | Package registry (OSV) |
| red hat:postgresql-tcl | 0:8.1.23-4.el5_8 · Red Hat:enterprise_linux:5::client | Package registry (OSV) |
| red hat:postgresql-test | 0:8.1.23-4.el5_8 · Red Hat:enterprise_linux:5::client_workstation | Package registry (OSV) |
| red hat:postgresql84 | 0:8.4.11-1.el5_8 · Red Hat:enterprise_linux:5::client | Package registry (OSV) |
Exploit status
No known public exploit
No public exploit has been observed yet. That doesn't mean you're safe, only that the bar is a little higher.
Research context
For pentesters and researchers: attack profile, score disagreement, timeline, patch commits, credits, variant and chain candidates, bug bounty scope. All derived from existing data; no exploit code.
Timeline
From publication to today: proof of concept, Metasploit module, CISA KEV and fix record. Dates are as reported by the sources.
No dated events beyond publication.
Not on record for this CVE: EPSS history · patch commit or PR link · researcher credit · variant or chain candidate · public bounty program.
Technical details
Attack conditions
- No special conditions are required; it is repeatable.
If successful
- Confidentiality
- P · data can be read
- Integrity
- P · data or configuration can be modified
- Availability
- P · the service can be disrupted
- Attack complexity
- Low
- Confidentiality impact
- P
- Integrity impact
- P
- Availability impact
- P
Weakness class (CWE)
CWE-264 · Permissions, Privileges, and Access ControlsCVSS vector
AV:N/AC:L/Au:S/C:P/I:P/A:P
nvd-primary
Attack context
MITRE CAPEC attack patterns and ATT&CK techniques for this weakness class (CWE). A starting point for detection rules and threat hunting.
MITRE has no CAPEC/ATT&CK mapping for this CWE.
Change log (1)
- Fix✗ → ✓
For records you follow, these changes also arrive as notifications. →
References
Show all references (14 more)Show less
- lists.opensuse.org/opensuse-updates/2012-09/msg00060.html
- rhn.redhat.com/errata/RHSA-2012-0677.html
- rhn.redhat.com/errata/RHSA-2012-0678.html
- secunia.com/advisories/49272
- secunia.com/advisories/49273
- www.debian.org/security/2012/dsa-2418
- www.mandriva.com/security/advisories?name=MDVSA-2012:026
- www.mandriva.com/security/advisories?name=MDVSA-2012:027
- www.mandriva.com/security/advisories?name=MDVSA-2012:092
- www.postgresql.org/about/news/1377/
- www.postgresql.org/docs/8.3/static/release-8-3-18.html
- www.postgresql.org/docs/8.4/static/release-8-4-11.html
- www.postgresql.org/docs/9.0/static/release-9-0-7.html
- www.postgresql.org/docs/9.1/static/release-9-1-3.html
Vendor advisories and official records. Exploit/PoC links are deliberately left out.