{"schemaVersion":3,"id":"CVE-2021-20229","aliases":["ALPINE-CVE-2021-20229","DEBIAN-CVE-2021-20229"],"status":"published","duplicateOf":null,"title":null,"description":"A flaw was found in PostgreSQL in versions before 13.2. This flaw allows a user with SELECT privilege on one column to craft a special query that returns all columns of the table. The highest threat from this vulnerability is to confidentiality.","dates":{"published":"2021-02-23T17:40:53.000Z","modified":"2024-08-03T17:30:07.427Z","reserved":null,"kevAdded":[],"kevDue":[]},"cvss":{"headline":{"score":4.3,"severity":"medium","version":"3.1","versionLabel":"v3.1","source":"NVD","vector":"CVSS:3.1/AV:N/AC:L/PR:L/UI:N/S:U/C:L/I:N/A:N","computed":false,"selection":"backend-summary"},"metrics":[{"version":"3.1","versionLabel":"v3.1","source":"OSV · Alpine","score":4.3,"severity":"medium","vector":"CVSS:3.1/AV:N/AC:L/PR:L/UI:N/S:U/C:L/I:N/A:N","exploitability":7.2,"impact":2.3,"computed":true},{"version":"3.1","versionLabel":"v3.1","source":"OSV · Debian","score":4.3,"severity":"medium","vector":"CVSS:3.1/AV:N/AC:L/PR:L/UI:N/S:U/C:L/I:N/A:N","exploitability":7.2,"impact":2.3,"computed":true},{"version":"3.1","versionLabel":"v3.1","source":"NVD","score":4.3,"severity":"medium","vector":"CVSS:3.1/AV:N/AC:L/PR:L/UI:N/S:U/C:L/I:N/A:N","exploitability":null,"impact":null,"computed":false},{"version":"2.0","versionLabel":"v2.0","source":"NVD","score":4,"severity":"medium","vector":"AV:N/AC:L/Au:S/C:P/I:N/A:N","exploitability":null,"impact":null,"computed":false}]},"epss":{"probability":0.01466,"percentile":0.73297,"severity":"low","asOf":"2026-10-19T00:00:00.000Z","change":{"pp":0,"baselineDate":"2026-09-19T00:00:00.000Z","baselineScore":0.01466},"history":[{"date":"2026-09-14T00:00:00.000Z","score":0.01466,"percentile":null},{"date":"2026-09-15T00:00:00.000Z","score":0.01466,"percentile":null},{"date":"2026-09-16T00:00:00.000Z","score":0.01466,"percentile":null},{"date":"2026-09-17T00:00:00.000Z","score":0.01466,"percentile":null},{"date":"2026-09-18T00:00:00.000Z","score":0.01466,"percentile":null},{"date":"2026-09-19T00:00:00.000Z","score":0.01466,"percentile":null},{"date":"2026-09-20T00:00:00.000Z","score":0.01466,"percentile":null},{"date":"2026-09-21T00:00:00.000Z","score":0.01466,"percentile":null},{"date":"2026-09-22T00:00:00.000Z","score":0.01466,"percentile":null},{"date":"2026-09-23T00:00:00.000Z","score":0.01466,"percentile":null},{"date":"2026-09-24T00:00:00.000Z","score":0.01466,"percentile":null},{"date":"2026-09-25T00:00:00.000Z","score":0.01466,"percentile":null},{"date":"2026-09-26T00:00:00.000Z","score":0.01466,"percentile":null},{"date":"2026-09-27T00:00:00.000Z","score":0.01466,"percentile":null},{"date":"2026-09-28T00:00:00.000Z","score":0.01466,"percentile":null},{"date":"2026-09-29T00:00:00.000Z","score":0.01466,"percentile":null},{"date":"2026-09-30T00:00:00.000Z","score":0.01466,"percentile":null},{"date":"2026-10-01T00:00:00.000Z","score":0.01466,"percentile":null},{"date":"2026-10-02T00:00:00.000Z","score":0.01466,"percentile":null},{"date":"2026-10-03T00:00:00.000Z","score":0.01466,"percentile":null},{"date":"2026-10-04T00:00:00.000Z","score":0.01466,"percentile":null},{"date":"2026-10-05T00:00:00.000Z","score":0.01466,"percentile":null},{"date":"2026-10-06T00:00:00.000Z","score":0.01466,"percentile":null},{"date":"2026-10-07T00:00:00.000Z","score":0.01466,"percentile":null},{"date":"2026-10-08T00:00:00.000Z","score":0.01466,"percentile":null},{"date":"2026-10-09T00:00:00.000Z","score":0.01466,"percentile":null},{"date":"2026-10-10T00:00:00.000Z","score":0.01466,"percentile":null},{"date":"2026-10-11T00:00:00.000Z","score":0.01466,"percentile":null},{"date":"2026-10-12T00:00:00.000Z","score":0.01466,"percentile":null},{"date":"2026-10-13T00:00:00.000Z","score":0.01466,"percentile":null},{"date":"2026-10-14T00:00:00.000Z","score":0.01466,"percentile":null},{"date":"2026-10-15T00:00:00.000Z","score":0.01466,"percentile":null},{"date":"2026-10-16T00:00:00.000Z","score":0.01466,"percentile":null},{"date":"2026-10-17T00:00:00.000Z","score":0.01466,"percentile":null},{"date":"2026-10-18T00:00:00.000Z","score":0.01466,"percentile":null},{"date":"2026-10-19T00:00:00.000Z","score":0.01466,"percentile":0.73297}],"last30":[{"date":"2026-09-19T00:00:00.000Z","score":0.01466,"percentile":null},{"date":"2026-09-20T00:00:00.000Z","score":0.01466,"percentile":null},{"date":"2026-09-21T00:00:00.000Z","score":0.01466,"percentile":null},{"date":"2026-09-22T00:00:00.000Z","score":0.01466,"percentile":null},{"date":"2026-09-23T00:00:00.000Z","score":0.01466,"percentile":null},{"date":"2026-09-24T00:00:00.000Z","score":0.01466,"percentile":null},{"date":"2026-09-25T00:00:00.000Z","score":0.01466,"percentile":null},{"date":"2026-09-26T00:00:00.000Z","score":0.01466,"percentile":null},{"date":"2026-09-27T00:00:00.000Z","score":0.01466,"percentile":null},{"date":"2026-09-28T00:00:00.000Z","score":0.01466,"percentile":null},{"date":"2026-09-29T00:00:00.000Z","score":0.01466,"percentile":null},{"date":"2026-09-30T00:00:00.000Z","score":0.01466,"percentile":null},{"date":"2026-10-01T00:00:00.000Z","score":0.01466,"percentile":null},{"date":"2026-10-02T00:00:00.000Z","score":0.01466,"percentile":null},{"date":"2026-10-03T00:00:00.000Z","score":0.01466,"percentile":null},{"date":"2026-10-04T00:00:00.000Z","score":0.01466,"percentile":null},{"date":"2026-10-05T00:00:00.000Z","score":0.01466,"percentile":null},{"date":"2026-10-06T00:00:00.000Z","score":0.01466,"percentile":null},{"date":"2026-10-07T00:00:00.000Z","score":0.01466,"percentile":null},{"date":"2026-10-08T00:00:00.000Z","score":0.01466,"percentile":null},{"date":"2026-10-09T00:00:00.000Z","score":0.01466,"percentile":null},{"date":"2026-10-10T00:00:00.000Z","score":0.01466,"percentile":null},{"date":"2026-10-11T00:00:00.000Z","score":0.01466,"percentile":null},{"date":"2026-10-12T00:00:00.000Z","score":0.01466,"percentile":null},{"date":"2026-10-13T00:00:00.000Z","score":0.01466,"percentile":null},{"date":"2026-10-14T00:00:00.000Z","score":0.01466,"percentile":null},{"date":"2026-10-15T00:00:00.000Z","score":0.01466,"percentile":null},{"date":"2026-10-16T00:00:00.000Z","score":0.01466,"percentile":null},{"date":"2026-10-17T00:00:00.000Z","score":0.01466,"percentile":null},{"date":"2026-10-18T00:00:00.000Z","score":0.01466,"percentile":null},{"date":"2026-10-19T00:00:00.000Z","score":0.01466,"percentile":0.73297}]},"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-863","name":"Incorrect Authorization","description":"The product performs an authorization check when an actor attempts to access a resource or perform an action, but it does not correctly perform the check.","type":"weakness","status":"Incomplete","abstraction":"Class","likelihoodOfExploit":"High","url":"https://cwe.mitre.org/data/definitions/863.html"}],"affected":[{"vendor":"alpine","product":"postgresql","name":"postgresql","label":"postgresql","ecosystem":"Alpine Linux","cpePart":null,"purl":"pkg:apk/alpine/postgresql","purlType":"apk","versions":[{"text":"≥ 13.0, < 12.6-r0","noFixRecorded":false,"fixedIn":null},{"text":"≥ 13.0, < 13.2-r0","noFixRecorded":false,"fixedIn":null}],"versionsText":"≥ 13.0, < 12.6-r0 | ≥ 13.0, < 13.2-r0","eol":null,"hubHref":null},{"vendor":"alpine","product":"postgresql13","name":"postgresql13","label":"postgresql13","ecosystem":"Alpine Linux","cpePart":null,"purl":"pkg:apk/alpine/postgresql13","purlType":"apk","versions":[{"text":"< 13.2-r0","noFixRecorded":false,"fixedIn":null}],"versionsText":"< 13.2-r0","eol":null,"hubHref":null},{"vendor":"alpine","product":"postgresql14","name":"postgresql14","label":"postgresql14","ecosystem":"Alpine Linux","cpePart":null,"purl":"pkg:apk/alpine/postgresql14","purlType":"apk","versions":[{"text":"< 13.2-r0","noFixRecorded":false,"fixedIn":null}],"versionsText":"< 13.2-r0","eol":null,"hubHref":null},{"vendor":"alpine","product":"postgresql15","name":"postgresql15","label":"postgresql15","ecosystem":"Alpine Linux","cpePart":null,"purl":"pkg:apk/alpine/postgresql15","purlType":"apk","versions":[{"text":"< 13.2-r0","noFixRecorded":false,"fixedIn":null}],"versionsText":"< 13.2-r0","eol":null,"hubHref":null},{"vendor":"debian","product":"postgresql-13","name":"postgresql-13","label":"postgresql-13","ecosystem":"Debian","cpePart":null,"purl":"pkg:deb/debian/postgresql-13","purlType":"deb","versions":[{"text":"< 13.2-1","noFixRecorded":false,"fixedIn":null}],"versionsText":"< 13.2-1","eol":null,"hubHref":null},{"vendor":"fedoraproject","product":"fedora","name":"fedora","label":"fedora","ecosystem":null,"cpePart":"o","purl":null,"purlType":null,"versions":[{"text":"33","noFixRecorded":false,"fixedIn":null}],"versionsText":"33","eol":{"isEol":true,"eolDate":"2021-11-30T00:00:00.000Z","matchMethod":"cpe","cycle":{"name":"33","label":"33","eolFrom":"2021-11-30T00:00:00.000Z","isLts":false,"isMaintained":false,"latestVersion":null},"product":{"name":"fedora","label":"Fedora Linux","category":"os"}},"hubHref":"/vendor/fedoraproject/fedora"},{"vendor":"postgresql","product":"postgresql","name":"postgresql","label":"postgresql","ecosystem":null,"cpePart":"a","purl":null,"purlType":null,"versions":[{"text":"≥ 13.0, < 13.2","noFixRecorded":false,"fixedIn":null}],"versionsText":"≥ 13.0, < 13.2","eol":{"isEol":null,"eolDate":null,"matchMethod":"cpe","cycle":null,"product":{"name":"postgresql","label":"PostgreSQL","category":"database"}},"hubHref":"/vendor/postgresql/postgresql"},{"vendor":"redhat","product":"enterprise_linux","name":"enterprise linux","label":"enterprise_linux","ecosystem":null,"cpePart":"o","purl":null,"purlType":null,"versions":[{"text":"7.0","noFixRecorded":false,"fixedIn":null},{"text":"8.0","noFixRecorded":false,"fixedIn":null}],"versionsText":"7.0 | 8.0","eol":{"isEol":true,"eolDate":"2024-06-30T00:00:00.000Z","matchMethod":"cpe","cycle":{"name":"7","label":"7 (ELS)","eolFrom":"2024-06-30T00:00:00.000Z","isLts":true,"isMaintained":true,"latestVersion":"7.9"},"product":{"name":"rhel","label":"Red Hat Enterprise Linux","category":"os"}},"hubHref":"/vendor/redhat/enterprise_linux"},{"vendor":"redhat","product":"software_collections","name":"software collections","label":"software_collections","ecosystem":null,"cpePart":"a","purl":null,"purlType":null,"versions":[{"text":"na","noFixRecorded":false,"fixedIn":null}],"versionsText":"na","eol":null,"hubHref":"/vendor/redhat/software_collections"}],"affectedCount":9,"eol":{"hasEol":true,"count":2},"references":[{"url":"https://bugzilla.redhat.com/show_bug.cgi?id=1925296","label":"bugzilla.redhat.com/show_bug.cgi?id=1925296","hostname":"bugzilla.redhat.com","tags":["X Refsource MISC","Issue Tracking","Third Party Advisory"]},{"url":"https://security.netapp.com/advisory/ntap-20210326-0005/","label":"security.netapp.com/advisory/ntap-20210326-0005/","hostname":"security.netapp.com","tags":["X Refsource CONFIRM","Third Party Advisory"]},{"url":"https://security.gentoo.org/glsa/202105-32","label":"security.gentoo.org/glsa/202105-32","hostname":"security.gentoo.org","tags":["Vendor Advisory","X Refsource GENTOO","Third Party Advisory"]},{"url":"https://security.alpinelinux.org/vuln/CVE-2021-20229","label":"security.alpinelinux.org/vuln/CVE-2021-20229","hostname":"security.alpinelinux.org","tags":["Advisory"]},{"url":"https://security-tracker.debian.org/tracker/CVE-2021-20229","label":"security-tracker.debian.org/tracker/CVE-2021-20229","hostname":"security-tracker.debian.org","tags":["Advisory"]},{"url":"https://nvd.nist.gov/vuln/detail/CVE-2021-20229","label":"nvd.nist.gov/vuln/detail/CVE-2021-20229","hostname":"nvd.nist.gov","tags":["Oval","Advisory"]}],"lineage":{"upstream":[],"downstream":["MGASA-2021-0121","OPENSUSE-SU-2024:11187-1","OPENSUSE-SU-2024:12387-1","OPENSUSE-SU-2024:13243-1","OPENSUSE-SU-2024:14360-1","OPENSUSE-SU-2025:15580-1","SUSE-SU-2021:0543-1","SUSE-SU-2021:0545-1"],"duplicates":[],"related":["OPENSUSE-SU-2024:11187-1","OPENSUSE-SU-2024:12387-1","OPENSUSE-SU-2024:13243-1","OPENSUSE-SU-2024:14360-1","OPENSUSE-SU-2025:15580-1","SUSE-SU-2021:0543-1","SUSE-SU-2021:0545-1"]},"timeline":[{"kind":"published","date":"2021-02-23T17:40:53.000Z","label":"Published","detail":"Vulnerability first disclosed.","source":null},{"kind":"modified","date":"2024-08-03T17:30:07.427Z","label":"Last modified","detail":"Vulnerability information updated.","source":null}],"risk":{"score":17,"level":"low","profile":"Default","thresholds":{"critical":75,"high":50,"medium":25,"low":10}},"meta":{"dataAsOf":"2026-10-19T19:34:32.877Z","stale":false,"partial":false}}