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.
Fixed in Linux distributions
Distributions backport fixes, so the version that fixes this vulnerability differs per release — upgrade to at least the version shown. From the distributions' security trackers and advisories.
Debian
Security tracker ↗| Release | Package | Fixed in | Advisory |
|---|---|---|---|
| Debian 6.0 | postgresql-8.4 | 8.4.11-0squeeze1 | DSA-2418-1 |
Red Hat
Security tracker ↗| Release | Package | Fixed in | Advisory |
|---|---|---|---|
| RHEL 6 | postgresql +9 | 8.4.11-1.el6_2 | RHSA-2012:0678 |
| RHEL 5 | postgresql +9 | 8.1.23-4.el5_8 | RHSA-2012:0677 |
| RHEL 5 | postgresql84 +11 | 8.4.11-1.el5_8 | RHSA-2012:0678 |
openSUSE
Security tracker ↗| Release | Package | Fixed in | Advisory |
|---|---|---|---|
| openSUSE Tumbleweed | postgresql93 | 9.3.15-1.1 | openSUSE-SU-2024:10256-1 |
| openSUSE Tumbleweed | postgresql94 | 9.4.10-1.1 | openSUSE-SU-2024:10030-1 |
| openSUSE Tumbleweed | postgresql95 | 9.5.4-1.2 | openSUSE-SU-2024:10273-1 |
Advisories 6
- RHSA-2012:0678 Red Hat Security Advisory: postgresql and postgresql84 security update Red Hat Security Advisories (RHSA) · Jun 26, 2026
- RHSA-2012:0677 Red Hat Security Advisory: postgresql security update Red Hat Security Advisories (RHSA) · Jun 26, 2026
- DSA-2418-1 postgresql-8.4 - several Debian Security (DSA / DLA) · Mar 9, 2026
- openSUSE-SU-2024:10030-1 postgresql94-9.4.10-1.1 on GA media SUSE / openSUSE Security Updates · Feb 4, 2026
- openSUSE-SU-2024:10273-1 libecpg6-32bit-9.5.4-1.2 on GA media SUSE / openSUSE Security Updates · Feb 4, 2026
- openSUSE-SU-2024:10256-1 postgresql93-9.3.15-1.1 on GA media SUSE / openSUSE Security Updates · May 7, 2025
References
- http://www.postgresql.org/about/news/1377/
- MDVSA-2012:027 vendor-advisory
- 49273 third-party-advisory
- RHSA-2012:0678 vendor-advisory
- MDVSA-2012:026 vendor-advisory
- http://www.postgresql.org/docs/9.0/static/release-9-0-7.html
- MDVSA-2012:092 vendor-advisory
- http://kb.juniper.net/InfoCenter/index?page=content&id=JSA10705
- http://www.postgresql.org/docs/8.4/static/release-8-4-11.html
- DSA-2418 vendor-advisory
- http://www.postgresql.org/docs/8.3/static/release-8-3-18.html
- 49272 third-party-advisory
- http://www.postgresql.org/docs/9.1/static/release-9-1-3.html
- RHSA-2012:0677 vendor-advisory
- openSUSE-SU-2012:1173 vendor-advisory