user/postgresql: CVE-2019-9193: "COPY ... PROGRAM" function code execution
| Bugzilla ID | 106 |
| Alias(es) | CVE-2019-9193 |
| Reporter | Max Rees (sroracle) |
| Assignee | Max Rees (sroracle) |
| Reported | 2019-07-24 02:37:29 -0500 |
| Modified | 2019-07-24 13:04:21 -0500 |
| Status | RESOLVED NOTABUG |
| Version | 1.0-BETA3 |
| Hardware | Adélie Linux / All |
| Importance | --- / normal |
| URL | https://nvd.nist.gov/vuln/detail/CVE-2019-9193 |
Description
According to upstream [1]:
The PostgreSQL Security Team would like to emphasize that this is not
a security vulnerability.
The COPY .. PROGRAM feature explicitly states that it can only be
executed by database users that have been granted superuser privileges
or the default role pg_execute_server_program. By design, this feature
allows one who is granted superuser or pg_execute_server_program to
perform actions as the operating system user the PostgreSQL server
runs under (normally "postgres"). The default roles
pg_read_server_files and pg_write_server_files that are mentioned in
the CVE do not grant permission for a database user to use COPY ..
PROGRAM.