Vulnerability-Lookup

CNVD-2019-08279

Vulnerability from cnvd - Published: 2019-03-27

Title

PostgreSQL任意代码执行漏洞

Description

PostgreSQL是数据库软件，可运行在所有主流操作系统上，包括Linux、Windows、Mac OS X等。 PostgreSQL存在任意代码执行漏洞。该漏洞存在于导入导出数据的命令“COPY TO/FROM PROGRAM””中，“pg_read_server_files”组内用户执行上述命令后，可获取数据库超级用户权限，攻击者利用此漏洞执行任意系统命令。

Severity

高

Patch Name

PostgreSQL任意代码执行漏洞的补丁

Patch Description

Formal description

用户可参考如下供应商提供的安全公告获得补丁信息： http://paper.tuisec.win/detail/66d2b3ec28c7239

Reference

http://paper.tuisec.win/detail/66d2b3ec28c7239

Impacted products

Name
PostgreSQL Postgresql >=9.3

Show details on source website

JSON

To clipboard

{
  "cves": {
    "cve": {
      "cveNumber": "CVE-2019-9193"
    }
  },
  "description": "PostgreSQL\u662f\u6570\u636e\u5e93\u8f6f\u4ef6\uff0c\u53ef\u8fd0\u884c\u5728\u6240\u6709\u4e3b\u6d41\u64cd\u4f5c\u7cfb\u7edf\u4e0a\uff0c\u5305\u62ecLinux\u3001Windows\u3001Mac OS X\u7b49\u3002\n\nPostgreSQL\u5b58\u5728\u4efb\u610f\u4ee3\u7801\u6267\u884c\u6f0f\u6d1e\u3002\u8be5\u6f0f\u6d1e\u5b58\u5728\u4e8e\u5bfc\u5165\u5bfc\u51fa\u6570\u636e\u7684\u547d\u4ee4\u201cCOPY TO/FROM PROGRAM\u201d\u201d\u4e2d\uff0c\u201cpg_read_server_files\u201d\u7ec4\u5185\u7528\u6237\u6267\u884c\u4e0a\u8ff0\u547d\u4ee4\u540e\uff0c\u53ef\u83b7\u53d6\u6570\u636e\u5e93\u8d85\u7ea7\u7528\u6237\u6743\u9650\uff0c\u653b\u51fb\u8005\u5229\u7528\u6b64\u6f0f\u6d1e\u6267\u884c\u4efb\u610f\u7cfb\u7edf\u547d\u4ee4\u3002",
  "discovererName": "unknwon",
  "formalWay": "\u7528\u6237\u53ef\u53c2\u8003\u5982\u4e0b\u4f9b\u5e94\u5546\u63d0\u4f9b\u7684\u5b89\u5168\u516c\u544a\u83b7\u5f97\u8865\u4e01\u4fe1\u606f\uff1a\r\nhttp://paper.tuisec.win/detail/66d2b3ec28c7239",
  "isEvent": "\u901a\u7528\u8f6f\u786c\u4ef6\u6f0f\u6d1e",
  "number": "CNVD-2019-08279",
  "openTime": "2019-03-27",
  "patchDescription": "PostgreSQL\u662f\u6570\u636e\u5e93\u8f6f\u4ef6\uff0c\u53ef\u8fd0\u884c\u5728\u6240\u6709\u4e3b\u6d41\u64cd\u4f5c\u7cfb\u7edf\u4e0a\uff0c\u5305\u62ecLinux\u3001Windows\u3001Mac OS X\u7b49\u3002\r\n\r\nPostgreSQL\u5b58\u5728\u4efb\u610f\u4ee3\u7801\u6267\u884c\u6f0f\u6d1e\u3002\u8be5\u6f0f\u6d1e\u5b58\u5728\u4e8e\u5bfc\u5165\u5bfc\u51fa\u6570\u636e\u7684\u547d\u4ee4\u201cCOPY TO/FROM PROGRAM\u201d\u201d\u4e2d\uff0c\u201cpg_read_server_files\u201d\u7ec4\u5185\u7528\u6237\u6267\u884c\u4e0a\u8ff0\u547d\u4ee4\u540e\uff0c\u53ef\u83b7\u53d6\u6570\u636e\u5e93\u8d85\u7ea7\u7528\u6237\u6743\u9650\uff0c\u653b\u51fb\u8005\u5229\u7528\u6b64\u6f0f\u6d1e\u6267\u884c\u4efb\u610f\u7cfb\u7edf\u547d\u4ee4\u3002\u76ee\u524d\uff0c\u4f9b\u5e94\u5546\u53d1\u5e03\u4e86\u5b89\u5168\u516c\u544a\u53ca\u76f8\u5173\u8865\u4e01\u4fe1\u606f\uff0c\u4fee\u590d\u4e86\u6b64\u6f0f\u6d1e\u3002",
  "patchName": "PostgreSQL\u4efb\u610f\u4ee3\u7801\u6267\u884c\u6f0f\u6d1e\u7684\u8865\u4e01",
  "products": {
    "product": "PostgreSQL Postgresql \u003e=9.3"
  },
  "referenceLink": "http://paper.tuisec.win/detail/66d2b3ec28c7239",
  "serverity": "\u9ad8",
  "submitTime": "2019-03-27",
  "title": "PostgreSQL\u4efb\u610f\u4ee3\u7801\u6267\u884c\u6f0f\u6d1e"
}

CVE-2019-9193 (GCVE-0-2019-9193)

Vulnerability from cvelistv5 – Published: 2019-04-01 00:00 – Updated: 2024-11-15 15:13 Disputed

Summary

In PostgreSQL 9.3 through 11.2, the "COPY TO/FROM PROGRAM" function allows superusers and users in the 'pg_execute_server_program' group to execute arbitrary code in the context of the database's operating system user. This functionality is enabled by default and can be abused to run arbitrary operating system commands on Windows, Linux, and macOS. NOTE: Third parties claim/state this is not an issue because PostgreSQL functionality for ‘COPY TO/FROM PROGRAM’ is acting as intended. References state that in PostgreSQL, a superuser can execute commands as the server user without using the ‘COPY FROM PROGRAM’.

Severity

No CVSS data available.

SSVC

Exploitation: none Automatable: no Technical Impact: total

CISA Coordinator · CISA-ADP (v2.0.3)

Decision recorded 2024-04-24 17:12 UTC

CWE

Assigner

mitre CNA under the mitre root

CNA scorecard E 28/100 over 2320 records in the last 180 days details

References

8 references

URL	Tags
https://paquier.xyz/postgresql-2/postgres-9-3-fea…
https://medium.com/greenwolf-security/authenticat…
https://blog.hagander.net/when-a-vulnerability-is…
https://www.trustwave.com/en-us/resources/blogs/s…
https://security.netapp.com/advisory/ntap-2019050…
http://packetstormsecurity.com/files/152757/Postg…
http://packetstormsecurity.com/files/166540/Postg…
http://packetstormsecurity.com/files/171722/Postg…

Date Public

2019-03-20 00:00

Show details on NVD website

JSON

To clipboard

{
  "containers": {
    "adp": [
      {
        "providerMetadata": {
          "dateUpdated": "2024-08-04T21:38:46.528Z",
          "orgId": "af854a3a-2127-422b-91ae-364da2661108",
          "shortName": "CVE"
        },
        "references": [
          {
            "tags": [
              "x_transferred"
            ],
            "url": "https://paquier.xyz/postgresql-2/postgres-9-3-feature-highlight-copy-tofrom-program/"
          },
          {
            "tags": [
              "x_transferred"
            ],
            "url": "https://medium.com/greenwolf-security/authenticated-arbitrary-command-execution-on-postgresql-9-3-latest-cd18945914d5"
          },
          {
            "tags": [
              "x_transferred"
            ],
            "url": "https://blog.hagander.net/when-a-vulnerability-is-not-a-vulnerability-244/"
          },
          {
            "tags": [
              "x_transferred"
            ],
            "url": "https://www.trustwave.com/en-us/resources/blogs/spiderlabs-blog/authenticated-arbitrary-command-execution-on-postgresql-9-3/"
          },
          {
            "tags": [
              "x_transferred"
            ],
            "url": "https://security.netapp.com/advisory/ntap-20190502-0003/"
          },
          {
            "tags": [
              "x_transferred"
            ],
            "url": "http://packetstormsecurity.com/files/152757/PostgreSQL-COPY-FROM-PROGRAM-Command-Execution.html"
          },
          {
            "tags": [
              "x_transferred"
            ],
            "url": "http://packetstormsecurity.com/files/166540/PostgreSQL-11.7-Remote-Code-Execution.html"
          },
          {
            "tags": [
              "x_transferred"
            ],
            "url": "http://packetstormsecurity.com/files/171722/PostgreSQL-9.6.1-Remote-Code-Execution.html"
          }
        ],
        "title": "CVE Program Container"
      },
      {
        "metrics": [
          {
            "other": {
              "content": {
                "id": "CVE-2019-9193",
                "options": [
                  {
                    "Exploitation": "none"
                  },
                  {
                    "Automatable": "no"
                  },
                  {
                    "Technical Impact": "total"
                  }
                ],
                "role": "CISA Coordinator",
                "timestamp": "2024-04-24T17:12:53.867918Z",
                "version": "2.0.3"
              },
              "type": "ssvc"
            }
          }
        ],
        "providerMetadata": {
          "dateUpdated": "2024-11-15T15:13:38.845Z",
          "orgId": "134c704f-9b21-4f2e-91b3-4a467353bcc0",
          "shortName": "CISA-ADP"
        },
        "title": "CISA ADP Vulnrichment"
      }
    ],
    "cna": {
      "affected": [
        {
          "product": "n/a",
          "vendor": "n/a",
          "versions": [
            {
              "status": "affected",
              "version": "n/a"
            }
          ]
        }
      ],
      "datePublic": "2019-03-20T00:00:00.000Z",
      "descriptions": [
        {
          "lang": "en",
          "value": "In PostgreSQL 9.3 through 11.2, the \"COPY TO/FROM PROGRAM\" function allows superusers and users in the \u0027pg_execute_server_program\u0027 group to execute arbitrary code in the context of the database\u0027s operating system user. This functionality is enabled by default and can be abused to run arbitrary operating system commands on Windows, Linux, and macOS. NOTE: Third parties claim/state this is not an issue because PostgreSQL functionality for \u2018COPY TO/FROM PROGRAM\u2019 is acting as intended. References state that in PostgreSQL, a superuser can execute commands as the server user without using the \u2018COPY FROM PROGRAM\u2019."
        }
      ],
      "problemTypes": [
        {
          "descriptions": [
            {
              "description": "n/a",
              "lang": "en",
              "type": "text"
            }
          ]
        }
      ],
      "providerMetadata": {
        "dateUpdated": "2023-04-06T00:00:00.000Z",
        "orgId": "8254265b-2729-46b6-b9e3-3dfca2d5bfca",
        "shortName": "mitre"
      },
      "references": [
        {
          "url": "https://paquier.xyz/postgresql-2/postgres-9-3-feature-highlight-copy-tofrom-program/"
        },
        {
          "url": "https://medium.com/greenwolf-security/authenticated-arbitrary-command-execution-on-postgresql-9-3-latest-cd18945914d5"
        },
        {
          "url": "https://blog.hagander.net/when-a-vulnerability-is-not-a-vulnerability-244/"
        },
        {
          "url": "https://www.trustwave.com/en-us/resources/blogs/spiderlabs-blog/authenticated-arbitrary-command-execution-on-postgresql-9-3/"
        },
        {
          "url": "https://security.netapp.com/advisory/ntap-20190502-0003/"
        },
        {
          "url": "http://packetstormsecurity.com/files/152757/PostgreSQL-COPY-FROM-PROGRAM-Command-Execution.html"
        },
        {
          "url": "http://packetstormsecurity.com/files/166540/PostgreSQL-11.7-Remote-Code-Execution.html"
        },
        {
          "url": "http://packetstormsecurity.com/files/171722/PostgreSQL-9.6.1-Remote-Code-Execution.html"
        }
      ],
      "tags": [
        "disputed"
      ]
    }
  },
  "cveMetadata": {
    "assignerOrgId": "8254265b-2729-46b6-b9e3-3dfca2d5bfca",
    "assignerShortName": "mitre",
    "cveId": "CVE-2019-9193",
    "datePublished": "2019-04-01T00:00:00.000Z",
    "dateReserved": "2019-02-26T00:00:00.000Z",
    "dateUpdated": "2024-11-15T15:13:38.845Z",
    "state": "PUBLISHED"
  },
  "dataType": "CVE_RECORD",
  "dataVersion": "5.1"
}

Sightings

Author	Source	Type	Date	Other

Nomenclature

Seen: The vulnerability was mentioned, discussed, or observed by the user.
Confirmed: The vulnerability has been validated from an analyst's perspective.
Published Proof of Concept: A public proof of concept is available for this vulnerability.
Exploited: The vulnerability was observed as exploited by the user who reported the sighting.
Patched: The vulnerability was observed as successfully patched by the user who reported the sighting.
Not exploited: The vulnerability was not observed as exploited by the user who reported the sighting.
Not confirmed: The user expressed doubt about the validity of the vulnerability.
Not patched: The vulnerability was not observed as successfully patched by the user who reported the sighting.

Vulnerability timeline

Sightings and recorded dates, grouped by day · UTC

Order JSON

Publication & reservation Sightings KEV catalogs Other timestamps

Loading timeline…

The MITRE ATT&CK techniques below are AI-generated suggestions, inferred from the description of the vulnerability by the CIRCL/vulnerability-attack-technique-classification-roberta-base model, served locally by ML-Gateway. They have not been verified by an analyst and are provided for guidance only.
The approach is described in our paper Mapping CVEs to MITRE ATT&CK Techniques: A Curated Gold-Set Classifier and the Limits of LLM-Assisted Label Expansion.
Browse all ATT&CK techniques and the vulnerabilities related to each.

Related by attack behaviour

Vulnerabilities whose description is nearest to this one in the vector space of the CIRCL/vulnerability-attack-technique-biencoder model. This is a similarity search over the bi-encoder space (plain cosine), not a classification, and it has no measured accuracy.

Action not permitted