# SUSE-SU-2019:3212-1: Security update for postgresql

> Incorrect directory permissions in PostgreSQL allowed unauthorized local access, potentially leading to data exposure or modification.

- **Severity:** Not scored
- **Exploited in the wild:** Not known
- **Login needed:** Not needed
- **Attackable:** Local or same network only
- **Victim action needed:** Not needed
- **Fix available:** Yes
- **Published:** 10 Dec 2019

## What is SUSE-SU-2019:3212-1?

SUSE-SU-2019:3212-1 is a vulnerability in postgresql, published on 10 Dec 2019. It can only be exploited from the same machine or local network, with no action from the victim.

### Official description

This update for postgresql fixes the following issues:

- Changed permissions, so that the directory can only be used by users 
  in the postgres group (bsc#1123886).
- Moved bash profile out of /var/lib to allow transactional updates (bsc#1100397).

## Which versions are affected by SUSE-SU-2019:3212-1?


| Package | Ecosystem | Affected | Fixed in |
| --- | --- | --- | --- |
| `postgresql` | SUSE:Linux Enterprise Module for Basesystem 15 | All versions | 10-8.3.1 |
| `postgresql` | SUSE:Linux Enterprise Module for Basesystem 15 SP1 | All versions | 10-8.3.1 |
| `postgresql` | SUSE:Linux Enterprise Module for Package Hub 15 | All versions | 10-8.3.1 |
| `postgresql` | SUSE:Linux Enterprise Module for Server Applications 15 | All versions | 10-8.3.1 |
| `postgresql` | SUSE:Linux Enterprise Module for Server Applications 15 SP1 | All versions | 10-8.3.1 |

## How do I fix SUSE-SU-2019:3212-1?

Apply the vendor's patch.

## Is SUSE-SU-2019:3212-1 being exploited?

There is no known exploitation of SUSE-SU-2019:3212-1 in the wild and no public exploit code.

## Fix prompt for AI coding agents

```text
Check this codebase for SUSE-SU-2019:3212-1 and fix it if it is affected.

What it is: SUSE-SU-2019:3212-1 is a vulnerability in postgresql, published on 10 Dec 2019. It can only be exploited from the same machine or local network, with no action from the victim.
Exploitation: There is no known exploitation of SUSE-SU-2019:3212-1 in the wild and no public exploit code.

Affected product: postgresql. No package-level version data is available, so check the vendor advisory linked from the reference page.

Task:
1. Search the dependency manifests and lockfiles (for example package.json, package-lock.json, requirements.txt, poetry.lock, uv.lock, pom.xml, build.gradle, go.mod, Cargo.lock, Gemfile.lock) and any Dockerfiles for the affected packages, including transitive dependencies.
2. If an affected version is in use, upgrade it to the fixed version for its release line with the project's package manager, so the lockfile is regenerated. Prefer the smallest upgrade that fixes it.
3. If there is no fix, or the upgrade would break the build, do not guess: explain the risk and the safest workaround instead.
4. Run the tests and summarise what changed and why.
5. If nothing in the project is affected, say so and change nothing.

Reference: https://insights.sbomify.com/SUSE-SU-2019-3212-1/ (Markdown: https://insights.sbomify.com/SUSE-SU-2019-3212-1/index.md)
```

## Sources

- OSV: https://osv.dev/vulnerability/SUSE-SU-2019:3212-1

---
From sbomify Insights: https://insights.sbomify.com/SUSE-SU-2019-3212-1/
Summaries are generated and may contain mistakes; the official description above is the record.