# CVE-2023-29927: Missing authorization in n/a

> Low-privileged users can bypass client-side access controls to directly modify database records in specific Sage 300 network configurations.

- **Severity:** Medium 4.3 (`CVSS:3.1/AV:N/AC:L/PR:L/UI:N/S:U/C:N/I:L/A:N`)
- **Exploited in the wild:** Not known
- **Login needed:** Any signed-in user
- **Attackable:** Over the internet
- **Victim action needed:** Not needed
- **Fix available:** No
- **Published:** 16 May 2023
- **Updated:** 23 Jan 2025
- **Also known as:** GHSA-qw6r-773c-w64h

## What is CVE-2023-29927?

CVE-2023-29927 is a medium-severity missing authorization vulnerability in n/a, published on 16 May 2023. Any signed-in user can exploit it over the network, with no action from the victim.

### Official description

Versions of Sage 300 through 2022 implement role-based access controls that are only enforced client-side. Low-privileged Sage users, particularly those on a workstation setup in the "Windows Peer-to-Peer Network" or "Client Server Network" Sage 300 configurations, could recover the SQL connection strings being used by Sage 300 and interact directly with the underlying database(s) to create, update, and delete all company records, bypassing the program’s role-based access controls.

Weakness: CWE-863 (Incorrect Authorization)

## Which versions are affected by CVE-2023-29927?

It affects 1 product.


Products: Sage Sage 300.

## How do I fix CVE-2023-29927?

No fix has been published for CVE-2023-29927 yet. Limit exposure of the affected software until one is available.

## Is CVE-2023-29927 being exploited?

It is not confirmed as exploited in the wild, but public exploit code for CVE-2023-29927 exists.

## Other vulnerabilities in n/a

- [CVE-2022-41397](https://insights.sbomify.com/CVE-2022-41397/): Hardcoded credentials in n/a (critical 9.8)
- [CVE-2022-41400](https://insights.sbomify.com/CVE-2022-41400/): Hardcoded credentials in n/a (critical 9.8)
- [CVE-2022-38583](https://insights.sbomify.com/CVE-2022-38583/): Missing authorization in n/a (high 7.8)
- [CVE-2021-45492](https://insights.sbomify.com/CVE-2021-45492/): Privilege escalation in n/a (high 7.8)
- [CVE-2022-41398](https://insights.sbomify.com/CVE-2022-41398/): Hardcoded credentials in n/a (high 7.5)

## Fix prompt for AI coding agents

```text
Check this codebase for CVE-2023-29927 and fix it if it is affected.

What it is: CVE-2023-29927 is a medium-severity missing authorization vulnerability in n/a, published on 16 May 2023. Any signed-in user can exploit it over the network, with no action from the victim.
Exploitation: It is not confirmed as exploited in the wild, but public exploit code for CVE-2023-29927 exists.

Affected product: n/a. 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/CVE-2023-29927/ (Markdown: https://insights.sbomify.com/CVE-2023-29927/index.md)
```

## Sources

- CVE record: https://www.cve.org/CVERecord?id=CVE-2023-29927
- NVD: https://nvd.nist.gov/vuln/detail/CVE-2023-29927
- OSV: https://osv.dev/vulnerability/CVE-2023-29927

---
From sbomify Insights: https://insights.sbomify.com/CVE-2023-29927/
Summaries are generated and may contain mistakes; the official description above is the record.