{"schemaVersion":3,"id":"CVE-2012-0866","aliases":[],"status":"published","duplicateOf":null,"title":null,"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.","dates":{"published":"2012-07-18T23:00:00.000Z","modified":"2024-08-06T18:38:15.058Z","reserved":null,"kevAdded":[],"kevDue":[]},"cvss":{"headline":{"score":6.5,"severity":"medium","version":"2.0","versionLabel":"v2.0","source":"NVD","vector":"AV:N/AC:L/Au:S/C:P/I:P/A:P","computed":false,"selection":"backend-summary"},"metrics":[{"version":"2.0","versionLabel":"v2.0","source":"NVD","score":6.5,"severity":"medium","vector":"AV:N/AC:L/Au:S/C:P/I:P/A:P","exploitability":null,"impact":null,"computed":false}]},"epss":{"probability":0.03625,"percentile":0.89392,"severity":"low","asOf":"2026-10-19T00:00:00.000Z","change":{"pp":0,"baselineDate":"2026-09-19T00:00:00.000Z","baselineScore":0.03625},"history":[{"date":"2026-09-14T00:00:00.000Z","score":0.03625,"percentile":null},{"date":"2026-09-15T00:00:00.000Z","score":0.03625,"percentile":null},{"date":"2026-09-16T00:00:00.000Z","score":0.03625,"percentile":null},{"date":"2026-09-17T00:00:00.000Z","score":0.03625,"percentile":null},{"date":"2026-09-18T00:00:00.000Z","score":0.03625,"percentile":null},{"date":"2026-09-19T00:00:00.000Z","score":0.03625,"percentile":null},{"date":"2026-09-20T00:00:00.000Z","score":0.03625,"percentile":null},{"date":"2026-09-21T00:00:00.000Z","score":0.03625,"percentile":null},{"date":"2026-09-22T00:00:00.000Z","score":0.03625,"percentile":null},{"date":"2026-09-23T00:00:00.000Z","score":0.03625,"percentile":null},{"date":"2026-09-24T00:00:00.000Z","score":0.03625,"percentile":null},{"date":"2026-09-25T00:00:00.000Z","score":0.03625,"percentile":null},{"date":"2026-09-26T00:00:00.000Z","score":0.03625,"percentile":null},{"date":"2026-09-27T00:00:00.000Z","score":0.03625,"percentile":null},{"date":"2026-09-28T00:00:00.000Z","score":0.03625,"percentile":null},{"date":"2026-09-29T00:00:00.000Z","score":0.03625,"percentile":null},{"date":"2026-09-30T00:00:00.000Z","score":0.03625,"percentile":null},{"date":"2026-10-01T00:00:00.000Z","score":0.03625,"percentile":null},{"date":"2026-10-02T00:00:00.000Z","score":0.03625,"percentile":null},{"date":"2026-10-03T00:00:00.000Z","score":0.03625,"percentile":null},{"date":"2026-10-04T00:00:00.000Z","score":0.03625,"percentile":null},{"date":"2026-10-05T00:00:00.000Z","score":0.03625,"percentile":null},{"date":"2026-10-06T00:00:00.000Z","score":0.03625,"percentile":null},{"date":"2026-10-07T00:00:00.000Z","score":0.03625,"percentile":null},{"date":"2026-10-08T00:00:00.000Z","score":0.03625,"percentile":null},{"date":"2026-10-09T00:00:00.000Z","score":0.03625,"percentile":null},{"date":"2026-10-10T00:00:00.000Z","score":0.03625,"percentile":null},{"date":"2026-10-11T00:00:00.000Z","score":0.03625,"percentile":null},{"date":"2026-10-12T00:00:00.000Z","score":0.03625,"percentile":null},{"date":"2026-10-13T00:00:00.000Z","score":0.03625,"percentile":null},{"date":"2026-10-14T00:00:00.000Z","score":0.03625,"percentile":null},{"date":"2026-10-15T00:00:00.000Z","score":0.03625,"percentile":null},{"date":"2026-10-16T00:00:00.000Z","score":0.03625,"percentile":null},{"date":"2026-10-17T00:00:00.000Z","score":0.03625,"percentile":null},{"date":"2026-10-18T00:00:00.000Z","score":0.03625,"percentile":null},{"date":"2026-10-19T00:00:00.000Z","score":0.03625,"percentile":0.89392}],"last30":[{"date":"2026-09-19T00:00:00.000Z","score":0.03625,"percentile":null},{"date":"2026-09-20T00:00:00.000Z","score":0.03625,"percentile":null},{"date":"2026-09-21T00:00:00.000Z","score":0.03625,"percentile":null},{"date":"2026-09-22T00:00:00.000Z","score":0.03625,"percentile":null},{"date":"2026-09-23T00:00:00.000Z","score":0.03625,"percentile":null},{"date":"2026-09-24T00:00:00.000Z","score":0.03625,"percentile":null},{"date":"2026-09-25T00:00:00.000Z","score":0.03625,"percentile":null},{"date":"2026-09-26T00:00:00.000Z","score":0.03625,"percentile":null},{"date":"2026-09-27T00:00:00.000Z","score":0.03625,"percentile":null},{"date":"2026-09-28T00:00:00.000Z","score":0.03625,"percentile":null},{"date":"2026-09-29T00:00:00.000Z","score":0.03625,"percentile":null},{"date":"2026-09-30T00:00:00.000Z","score":0.03625,"percentile":null},{"date":"2026-10-01T00:00:00.000Z","score":0.03625,"percentile":null},{"date":"2026-10-02T00:00:00.000Z","score":0.03625,"percentile":null},{"date":"2026-10-03T00:00:00.000Z","score":0.03625,"percentile":null},{"date":"2026-10-04T00:00:00.000Z","score":0.03625,"percentile":null},{"date":"2026-10-05T00:00:00.000Z","score":0.03625,"percentile":null},{"date":"2026-10-06T00:00:00.000Z","score":0.03625,"percentile":null},{"date":"2026-10-07T00:00:00.000Z","score":0.03625,"percentile":null},{"date":"2026-10-08T00:00:00.000Z","score":0.03625,"percentile":null},{"date":"2026-10-09T00:00:00.000Z","score":0.03625,"percentile":null},{"date":"2026-10-10T00:00:00.000Z","score":0.03625,"percentile":null},{"date":"2026-10-11T00:00:00.000Z","score":0.03625,"percentile":null},{"date":"2026-10-12T00:00:00.000Z","score":0.03625,"percentile":null},{"date":"2026-10-13T00:00:00.000Z","score":0.03625,"percentile":null},{"date":"2026-10-14T00:00:00.000Z","score":0.03625,"percentile":null},{"date":"2026-10-15T00:00:00.000Z","score":0.03625,"percentile":null},{"date":"2026-10-16T00:00:00.000Z","score":0.03625,"percentile":null},{"date":"2026-10-17T00:00:00.000Z","score":0.03625,"percentile":null},{"date":"2026-10-18T00:00:00.000Z","score":0.03625,"percentile":null},{"date":"2026-10-19T00:00:00.000Z","score":0.03625,"percentile":0.89392}]},"kev":{"state":"not-listed","entries":[],"listedCount":0,"totalCatalogs":3,"catalogs":[{"source":"cisa","label":"CISA","listed":false,"entry":null},{"source":"enisa","label":"ENISA","listed":false,"entry":null},{"source":"circl","label":"CIRCL","listed":false,"entry":null}]},"ransomware":{"state":"none-recorded","sources":[]},"exploits":[],"exploitCount":0,"weaknesses":[{"id":"CWE-264","name":"Permissions, Privileges, and Access Controls","description":"Weaknesses in this category are related to the management of permissions, privileges, and other security features that are used to perform access control.","type":"category","status":"Obsolete","abstraction":null,"likelihoodOfExploit":null,"url":"https://cwe.mitre.org/data/definitions/264.html"}],"affected":[{"vendor":"postgresql","product":"postgresql","name":"postgresql","label":"postgresql","ecosystem":null,"cpePart":"a","purl":null,"purlType":null,"versions":[{"text":"8.3","noFixRecorded":false,"fixedIn":null},{"text":"8.3.1","noFixRecorded":false,"fixedIn":null},{"text":"8.3.2","noFixRecorded":false,"fixedIn":null},{"text":"8.3.3","noFixRecorded":false,"fixedIn":null},{"text":"8.3.4","noFixRecorded":false,"fixedIn":null},{"text":"8.3.5","noFixRecorded":false,"fixedIn":null},{"text":"8.3.6","noFixRecorded":false,"fixedIn":null},{"text":"8.3.7","noFixRecorded":false,"fixedIn":null},{"text":"8.3.8","noFixRecorded":false,"fixedIn":null},{"text":"8.3.9","noFixRecorded":false,"fixedIn":null},{"text":"8.3.10","noFixRecorded":false,"fixedIn":null},{"text":"8.3.11","noFixRecorded":false,"fixedIn":null},{"text":"8.3.12","noFixRecorded":false,"fixedIn":null},{"text":"8.3.13","noFixRecorded":false,"fixedIn":null},{"text":"8.3.14","noFixRecorded":false,"fixedIn":null},{"text":"8.3.15","noFixRecorded":false,"fixedIn":null},{"text":"8.3.16","noFixRecorded":false,"fixedIn":null},{"text":"8.3.17","noFixRecorded":false,"fixedIn":null},{"text":"8.4","noFixRecorded":false,"fixedIn":null},{"text":"8.4.1","noFixRecorded":false,"fixedIn":null},{"text":"8.4.2","noFixRecorded":false,"fixedIn":null},{"text":"8.4.3","noFixRecorded":false,"fixedIn":null},{"text":"8.4.4","noFixRecorded":false,"fixedIn":null},{"text":"8.4.5","noFixRecorded":false,"fixedIn":null},{"text":"8.4.6","noFixRecorded":false,"fixedIn":null},{"text":"8.4.7","noFixRecorded":false,"fixedIn":null},{"text":"8.4.8","noFixRecorded":false,"fixedIn":null},{"text":"8.4.9","noFixRecorded":false,"fixedIn":null},{"text":"8.4.10","noFixRecorded":false,"fixedIn":null},{"text":"9.0","noFixRecorded":false,"fixedIn":null},{"text":"9.0.1","noFixRecorded":false,"fixedIn":null},{"text":"9.0.2","noFixRecorded":false,"fixedIn":null},{"text":"9.0.3","noFixRecorded":false,"fixedIn":null},{"text":"9.0.4","noFixRecorded":false,"fixedIn":null},{"text":"9.0.5","noFixRecorded":false,"fixedIn":null},{"text":"9.0.6","noFixRecorded":false,"fixedIn":null},{"text":"9.1","noFixRecorded":false,"fixedIn":null},{"text":"9.1.1","noFixRecorded":false,"fixedIn":null},{"text":"9.1.2","noFixRecorded":false,"fixedIn":null}],"versionsText":"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 | 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 | 9.0 | 9.0.1 | 9.0.2 | 9.0.3 | 9.0.4 | 9.0.5 | 9.0.6 | 9.1 | 9.1.1 | 9.1.2","eol":{"isEol":true,"eolDate":"2013-02-07T00:00:00.000Z","matchMethod":"cpe","cycle":{"name":"8.3","label":"8.3","eolFrom":"2013-02-07T00:00:00.000Z","isLts":false,"isMaintained":false,"latestVersion":"8.3.23"},"product":{"name":"postgresql","label":"PostgreSQL","category":"database"}},"hubHref":"/vendor/postgresql/postgresql"}],"affectedCount":1,"eol":{"hasEol":true,"count":1},"references":[{"url":"http://www.postgresql.org/about/news/1377/","label":"www.postgresql.org/about/news/1377/","hostname":"www.postgresql.org","tags":["X Refsource CONFIRM","Vendor Advisory"]},{"url":"http://www.mandriva.com/security/advisories?name=MDVSA-2012:027","label":"www.mandriva.com/security/advisories?name=MDVSA-2012:027","hostname":"www.mandriva.com","tags":["Vendor Advisory","X Refsource MANDRIVA"]},{"url":"http://secunia.com/advisories/49273","label":"secunia.com/advisories/49273","hostname":"secunia.com","tags":["Third Party Advisory","X Refsource SECUNIA"]},{"url":"http://rhn.redhat.com/errata/RHSA-2012-0678.html","label":"rhn.redhat.com/errata/RHSA-2012-0678.html","hostname":"rhn.redhat.com","tags":["Vendor Advisory","X Refsource REDHAT"]},{"url":"http://www.mandriva.com/security/advisories?name=MDVSA-2012:026","label":"www.mandriva.com/security/advisories?name=MDVSA-2012:026","hostname":"www.mandriva.com","tags":["Vendor Advisory","X Refsource MANDRIVA"]},{"url":"http://www.postgresql.org/docs/9.0/static/release-9-0-7.html","label":"www.postgresql.org/docs/9.0/static/release-9-0-7.html","hostname":"www.postgresql.org","tags":["X Refsource CONFIRM"]},{"url":"http://www.mandriva.com/security/advisories?name=MDVSA-2012:092","label":"www.mandriva.com/security/advisories?name=MDVSA-2012:092","hostname":"www.mandriva.com","tags":["Vendor Advisory","X Refsource MANDRIVA"]},{"url":"http://kb.juniper.net/InfoCenter/index?page=content&id=JSA10705","label":"kb.juniper.net/InfoCenter/index?page=content&id=JSA10705","hostname":"kb.juniper.net","tags":["X Refsource CONFIRM"]},{"url":"http://www.postgresql.org/docs/8.4/static/release-8-4-11.html","label":"www.postgresql.org/docs/8.4/static/release-8-4-11.html","hostname":"www.postgresql.org","tags":["X Refsource CONFIRM"]},{"url":"http://www.debian.org/security/2012/dsa-2418","label":"www.debian.org/security/2012/dsa-2418","hostname":"www.debian.org","tags":["Vendor Advisory","X Refsource DEBIAN"]},{"url":"http://www.postgresql.org/docs/8.3/static/release-8-3-18.html","label":"www.postgresql.org/docs/8.3/static/release-8-3-18.html","hostname":"www.postgresql.org","tags":["X Refsource CONFIRM"]},{"url":"http://secunia.com/advisories/49272","label":"secunia.com/advisories/49272","hostname":"secunia.com","tags":["Third Party Advisory","X Refsource SECUNIA"]},{"url":"http://www.postgresql.org/docs/9.1/static/release-9-1-3.html","label":"www.postgresql.org/docs/9.1/static/release-9-1-3.html","hostname":"www.postgresql.org","tags":["X Refsource CONFIRM"]},{"url":"http://rhn.redhat.com/errata/RHSA-2012-0677.html","label":"rhn.redhat.com/errata/RHSA-2012-0677.html","hostname":"rhn.redhat.com","tags":["Vendor Advisory","X Refsource REDHAT"]},{"url":"http://lists.opensuse.org/opensuse-updates/2012-09/msg00060.html","label":"lists.opensuse.org/opensuse-updates/2012-09/msg00060.html","hostname":"lists.opensuse.org","tags":["Vendor Advisory","X Refsource SUSE"]}],"lineage":{"upstream":[],"downstream":["DSA-2418-1","OPENSUSE-SU-2024:10030-1","OPENSUSE-SU-2024:10256-1","OPENSUSE-SU-2024:10273-1","RHSA-2012:0677","RHSA-2012:0678"],"duplicates":[],"related":["OPENSUSE-SU-2024:10030-1","OPENSUSE-SU-2024:10256-1","OPENSUSE-SU-2024:10273-1"]},"timeline":[{"kind":"published","date":"2012-07-18T23:00:00.000Z","label":"Published","detail":"Vulnerability first disclosed.","source":null},{"kind":"modified","date":"2024-08-06T18:38:15.058Z","label":"Last modified","detail":"Vulnerability information updated.","source":null}],"risk":{"score":27,"level":"medium","profile":"Default","thresholds":{"critical":75,"high":50,"medium":25,"low":10}},"meta":{"dataAsOf":"2026-10-20T12:57:20.394Z","stale":false,"partial":false}}