postgresql: Absent permission checks on trigger function to be called when creating a trigger
Published Jul 18, 2012
6.5
MEDIUMCVSS 2.0
EPSS 3.62%
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.
Affected products
No data.
Configuration 1
- 8.3
- 8.3.1
- 8.3.2
- 8.3.3
- 8.3.4
- 8.3.5
- 8.3.6
- 8.3.7
- 8.3.8
- 8.3.9
- 8.3.10
- 8.3.11
- 8.3.12
- 8.3.13
- 8.3.14
- 8.3.15
- 8.3.16
- 8.3.17
Configuration 2
- 8.4
- 8.4.1
- 8.4.2
- 8.4.3
- 8.4.4
- 8.4.5
- 8.4.6
- 8.4.7
- 8.4.8
- 8.4.9
- 8.4.10
Configuration 3
- 9.0
- 9.0.1
- 9.0.2
- 9.0.3
- 9.0.4
- 9.0.5
- 9.0.6
Configuration 4
- 9.1
- 9.1.1
- 9.1.2
No data.
Red Hat Enterprise Linux 5
postgresql-0:8.1.23-4.el5_8
Fixed · RHSA-2012:0677
Red Hat Enterprise Linux 5
postgresql84-0:8.4.11-1.el5_8
Fixed · RHSA-2012:0678
Red Hat Enterprise Linux 6
postgresql-0:8.4.11-1.el6_2
Fixed · RHSA-2012:0678
Red Hat Enterprise Linux 4
postgresql
Will not fix
| Product | Package | State | Advisory |
|---|---|---|---|
| Red Hat Enterprise Linux 5 | postgresql-0:8.1.23-4.el5_8 | Fixed | RHSA-2012:0677 |
| Red Hat Enterprise Linux 5 | postgresql84-0:8.4.11-1.el5_8 | Fixed | RHSA-2012:0678 |
| Red Hat Enterprise Linux 6 | postgresql-0:8.4.11-1.el6_2 | Fixed | RHSA-2012:0678 |
| Red Hat Enterprise Linux 4 | postgresql | Will not fix | n/a |
No package ranges for this CVE.
Remediation
No remediation recorded yet.
Metrics
No CVSS v4.0 score for this CVE.
No CVSS v3.1 score for this CVE.
No CVSS v3.0 score for this CVE.
AV:N/AC:L/Au:S/C:P/I:P/A:P
This CVE is not in the KEV list.
No CISA SSVC assessment for this CVE yet.
Estimated probability of exploitation in the wild in the next 30 days (FIRST EPSS). As of Oct 1, 2026.
Score over time
2022–2026- EPSS v2
- EPSS v3
- EPSS v4
- EPSS v5
Percentile over time
- EPSS v2
- EPSS v3
- EPSS v4
- EPSS v5
Table of values (13 key points)
Flat stretches are collapsed; showing up to 120 newest points.
| Date | Score | Percentile | Model |
|---|---|---|---|
| Oct 1, 2026 | 3.62% (0.03625) | 89.16th | v5 (v2026.06.15) |
| Jun 15, 2026 | 3.62% (0.03625) | 88.01th | v5 (v2026.06.15) |
| Mar 30, 2025 | 1.08% (0.01081) | 75.86th | v4 (v2025.03.14) |
| Mar 29, 2025 | 3.05% (0.03051) | 77.75th | v4 (v2025.03.14) |
| Mar 17, 2025 | 1.08% (0.01081) | 76.31th | v4 (v2025.03.14) |
| Dec 12, 2024 | 0.44% (0.00442) | 75.70th | v3 (v2023.03.01) |
| Feb 8, 2024 | 0.44% (0.00442) | 74.13th | v3 (v2023.03.01) |
| Mar 7, 2023 | 0.44% (0.00442) | 70.87th | v3 (v2023.03.01) |
| Mar 6, 2023 | 2.19% (0.02186) | 80.97th | v2 (v2022.01.01) |
| Feb 13, 2023 | 2.19% (0.02186) | 80.49th | v2 (v2022.01.01) |
| Feb 3, 2023 | 2.53% (0.02528) | 81.34th | v2 (v2022.01.01) |
| Apr 1, 2022 | 2.19% (0.02186) | 79.16th | v2 (v2022.01.01) |
| Feb 4, 2022 | 2.19% (0.02186) | 57.93th | v2 (v2022.01.01) |
References (19)
- http://kb.juniper.net/InfoCenter/index?page=content&id=JSA10705 x_refsource_CONFIRM
- http://lists.opensuse.org/opensuse-updates/2012-09/msg00060.html vendor-advisoryx_refsource_SUSE
- http://rhn.redhat.com/errata/RHSA-2012-0677.html vendor-advisoryx_refsource_REDHAT
- http://rhn.redhat.com/errata/RHSA-2012-0678.html vendor-advisoryx_refsource_REDHAT
- http://secunia.com/advisories/49272 third-party-advisoryx_refsource_SECUNIA
- http://secunia.com/advisories/49273 third-party-advisoryx_refsource_SECUNIA
- http://www.debian.org/security/2012/dsa-2418 vendor-advisoryx_refsource_DEBIAN
- http://www.mandriva.com/security/advisories?name=MDVSA-2012:026 vendor-advisoryx_refsource_MANDRIVA
- http://www.mandriva.com/security/advisories?name=MDVSA-2012:027 vendor-advisoryx_refsource_MANDRIVA
- http://www.mandriva.com/security/advisories?name=MDVSA-2012:092 vendor-advisoryx_refsource_MANDRIVA
- http://www.postgresql.org/about/news/1377/ x_refsource_CONFIRMVendor Advisory
- http://www.postgresql.org/docs/8.3/static/release-8-3-18.html x_refsource_CONFIRM
- http://www.postgresql.org/docs/8.4/static/release-8-4-11.html x_refsource_CONFIRM
- http://www.postgresql.org/docs/9.0/static/release-9-0-7.html x_refsource_CONFIRM
- http://www.postgresql.org/docs/9.1/static/release-9-1-3.html x_refsource_CONFIRM
- https://access.redhat.com/security/cve/CVE-2012-0866 Vendor Advisory
- https://bugzilla.redhat.com/show_bug.cgi?id=797222 Issue Tracking
- https://nvd.nist.gov/vuln/detail/CVE-2012-0866
- https://www.cve.org/CVERecord?id=CVE-2012-0866
Change history (0)
No recorded changes yet.