News for hackers. Stuff that matters.
Re:Apple requires account deletion within apps in AppStore s... by fuddle on Wednesday October 06, 2021 @05:17PM (#28778563)
Can confirm, I worked at a fintech company previously with a large number of users. They had a "deleted_at" column on the user table in the database. It's not actually deleted.
Re:Apple requires account deletion within apps in AppStore s... by nawgz on Wednesday October 06, 2021 @05:30PM (#28778715)
Isn't this almost necessarily true for any system which needs an auditable history?

Just thinking out loud, of course cascading deletes will fail, so I guess you could avoid using true foreign keys to the user table for things which are truly related, and then you'd know what the user did but presumably no PII... Seems insanely sketchy though. Way cleaner to soft delete if you ever need to recover history, which the fintech context amongs many obviously requires

Re:Apple requires account deletion within apps in AppStore s... by codedokode on Wednesday October 06, 2021 @06:39PM (#28779374)
You don't need to delete the rows from the database. Just replace user's name, address and phone with random data.
Re:Apple requires account deletion within apps in AppStore s... by sneak on Wednesday October 06, 2021 @07:51PM (#28779972)
Regulated financial services must also store the documentation and results for how they verified a user's identity, too. This involves talking to third parties that can tell you if a given user's name matches their tax identifiers, street addresses, phone number, et cetera.

Anyone competent is storing both their requests to those external APIs, as well as those responses, for the entirety of the recordkeeping requirement period.

Re:Apple requires account deletion within apps in AppStore s... by xxs on Wednesday October 06, 2021 @06:53PM (#28779508)
The company needs 7 to 10 years of audit info. Of course they cannot 'delete' any account.