I should delete about 150 survey admins from the system. (Old accounts automatically generated by shibboleth login -- I did my own plugin for that.) I suppose that some of them has surveys but most do not. Ideas? For example, if I try to drop them from DB, will the system just delete all of them (no foreign key constraints), delete those that have no surveys (normal constraint) or even delete surveys (on delete cascade)?

What tables contains references to users? I just noticed that lime_permissions is not cleaned when I normally deleted a user. Shadow user is not shown, so this is not a big thing.

Just raising this up... I guess that the spirit of GDPR requires me to think about this issue.

User id are inside
1. Survey as owner_id
2. permission as user id
3. Participant (global) (unsure where).
github.com/LimeSurvey/LimeSurvey/blob/56.../useraction.php#L287

Maybe best is to create a remote control function ?
gitlab.com/SondagesPro/RemoteControl/extendRemoteControl

Participant? I have thought that list of admins and list of people in CPDB are totally different. (In my case there is no CPDB at all, so this is theoretical for me.)

So, only two places where I should remove accounts. I guess I can do that.

Of course the more complicated issue is surveys without an owner, but for that I think there can be no mechanical solution.

Best seems to move owner to 1 if owner is deleted ?

It is technically easy solution. But I guess we must go through them one by one and think what should be preserved for some reason, and what should be deleted for GDPR and generally for cleaning up unnecessary surveys. So this is question that has both technical and political sides.

Then, about user account: a user might be the owner of survey group. So it is harder that just two DB tables.

Ah !

Whene user deteleted : seems it was not deleted from User group too (LimeSurvey issue).

> a user might be the owner of survey group

Right … must be fixed too.

OK. Is it possible for the update script to also clean up DB for possible shadow data like this?

Why there are no foreing keys in the DB in the first place?

> a user might be the owner of survey group
Right … must be fixed too.

It there an issue opened about this in the bug tracker?

Jmantysalo wrote:

> a user might be the owner of survey group
Right … must be fixed too.

It there an issue opened about this in the bug tracker?Not
 

Not by me

OK, I did bugs.limesurvey.org/view.php?id=17659