CVE-2024-58356
SurrealDB has Silent Failure to Overwrite Table Definition of Relation Type
Impact
The `OVERWRITE` clause of the `DEFINE TABLE` statement would fail to overwrite data for tables that were defined with `TYPE RELATION`. Since table definitions include the `PERMISSIONS` clause, this failure would result in permissions not being overwritten as a result, which may potentially lead users to believe they have changed the table permissions when they have not. ### Impact If a user attempted to update table permissions of a table defined with `TYPE RELATION` using `DEFINE TABLE ... OVERWRITE`, permissions for the table would not be changed. This may allow a client that is authorized to run queries in a SurrealDB server to access certain data in that specific table that they were not intended to be able to access after the specified change in permissions. ### Patches The `DEFINE TABLE` statement has been updated to appropriately overwrite data for tables defined with `TYPE RELATION`. - Version 2.1.4 and later are not affected by this issue. ### Workarounds Users of tables with `TYPE RELATION` that may have been modified using the `OVERWRITE` clause in order to update permissions are advised to verify that the intended permissions are in place using the `INFO FOR DB` statement. Affected users who are unable to update and require updating permissions in a table with `TYPE RELATION` will be required to remove the table and define it from scratch with the intended permissions. Data can be preserved by backing it up to a temporary table. ### References - [#5260](https://github.com/surrealdb/surrealdb/pull/5260)
Affected packages
| Ecosystem | Package | Affected | Fixed in |
|---|---|---|---|
| rust | surrealdb | >= 2.0.0, < 2.1.4 | 2.1.4 |
| rust | surrealdb-core | >= 2.0.0, < 2.1.4 | 2.1.4 |
Affected products
| Vendor | Product | Affected versions |
|---|---|---|
| Surrealdb | Surrealdb | from 2.0.0 before 2.1.4 |
Weakness classification
References
- NVD record
- CVE.org record
- GitHub advisory
- https://github.com/surrealdb/surrealdb/security/advisories/GHSA-27vq-hv74-7cqp
- https://www.vulncheck.com/advisories/surrealdb-before-permission-bypass-via-define-table-overwrite
- https://github.com/advisories/GHSA-27vq-hv74-7cqp
- https://github.com/surrealdb/surrealdb/pull/5260
- https://github.com/surrealdb/surrealdb/commit/2f9a58f830c24f107b4783da1f0704a502bc7734
- https://nvd.nist.gov/vuln/detail/CVE-2024-58356