View Issue Details

IDProjectCategoryView StatusLast Update
0006074Composrcore_privacypublic2024-11-28 17:18
ReporterPatrick SchmalstigAssigned To 
SeverityFeature-request 
Status non-assignedResolutionopen 
Product Version 
Fixed in Version 
Summary0006074: Handle privacy within the revisions system
DescriptionWhen a member requests to be purged, they have the right to be forgotten.

But we may still have their data in a Resource-fs format stored within the revisions system / table. We must account for this to be GDPR-compliant.

We can't just simply delete any matched revisions record; maybe a member who wants to be anonymised did not submit a particular piece of content in the revisions system. We must anonymise their e-mail address within the Resource-fs data while preserving the rest.

Luckily, it looks like revisions stores Resource-fs data as JSON. So doing a str_replace wouldn't be that difficult. The difficult part is matching the JSON schema to the db_meta to determine which fields need anonymised and to what criteria they belong.
Additional InformationProbably not something that will be done for v11.0 as this is a very complex issue. But it should be done within the v11.x branch as it's semi-high priority (given it regards legal compliance).
TagsRoadmap: Over the horizon, Type: Legal compliance / Privacy
Time estimation (hours)
Sponsorship open

Relationships

related to 0006073 resolvedPatrick Schmalstig We need a special field type for serialized data 

Activities

Patrick Schmalstig

2024-11-28 17:17

administrator   ~0009692

Last edited: 2024-11-28 17:18

View 2 revisions

This also requires yet another new db field type for Composr: JSON. Just like SERIAL, this will probably just be an alias of LONG_TEXT.

Issue History

Date Modified Username Field Change
2024-11-28 17:15 Patrick Schmalstig New Issue
2024-11-28 17:15 Patrick Schmalstig Tag Attached: Roadmap: Over the horizon
2024-11-28 17:15 Patrick Schmalstig Tag Attached: Type: Legal compliance / Privacy
2024-11-28 17:17 Patrick Schmalstig Note Added: 0009692
2024-11-28 17:17 Patrick Schmalstig Relationship added related to 0006073
2024-11-28 17:18 Patrick Schmalstig Note Edited: 0009692 View Revisions