Live data from Hacker News

Instead of deleting account, NYT appends ‘1000’ to username and email address

twitter.com

91–100 of 167 posts

Re: Instead of deleting account, NYT appends ‘1000’ to username and email address

#91
post #84

Earlier quoted context omitted.

I used to work where (not a service for the general public) there was an "is deleted" flag for everything, but every now and then a client would insist that data be really deleted, and depending on who it was and how they asked, we might go and do it, which was a huge hassle and would cause no end of problems down the line. On the other hand, "is deleted" flags end up causing issues when you forget to put "where not…

>On the other hand, "is deleted" flags end up causing issues when you forget to put "where not is_deleted" in your queries. My solution would be a view for every table. Are there drawbacks? Other solutions?

Eh, the situation that I've been in, if I recall correctly, is that one has read/write access to all data for reporting, but not the ability to create views (or stored procedures etc) to share.

Where I am now, (as far as Oracle goes) you can't even create your own tables under your own schema. A view requires a meeting with a DBA and their manager and really special, compelling arguments.

Re: Instead of deleting account, NYT appends ‘1000’ to username and email address

#92
post #64

Doing real deletes on user accounts is a surprisingly challenging problem and I'd be willing to bet very few companies do real deletes where all of your data is wiped permanently from the company. For legal and financial reasons, companies often need to keep track of historical user activity. If a company states in their investor quarterly report that they had 1M active users, they better be able to prove it in an au…

Soft deletion violates the GDPR.

Read article 17:

https://gdpr-info.eu/art-17-gdpr/

And previous HN discussions:

https://news.ycombinator.com/item?id=16366050

Re: Instead of deleting account, NYT appends ‘1000’ to username and email address

#93
post #64

Doing real deletes on user accounts is a surprisingly challenging problem and I'd be willing to bet very few companies do real deletes where all of your data is wiped permanently from the company. For legal and financial reasons, companies often need to keep track of historical user activity. If a company states in their investor quarterly report that they had 1M active users, they better be able to prove it in an au…

Soft deletion violates the GDPR. Read article 17: https://gdpr-info.eu/art-17-gdpr/ And previous HN discussions: https://news.ycombinator.com/item?id=16366050

Did a glance through that thread and it didn't seem like there was a strong consensus on how to respect GPDR while maintaining historical data for reporting purposes. Any best practices?

Re: Instead of deleting account, NYT appends ‘1000’ to username and email address

#94
post #64

Doing real deletes on user accounts is a surprisingly challenging problem and I'd be willing to bet very few companies do real deletes where all of your data is wiped permanently from the company. For legal and financial reasons, companies often need to keep track of historical user activity. If a company states in their investor quarterly report that they had 1M active users, they better be able to prove it in an au…

Soft deletion violates the GDPR. Read article 17: https://gdpr-info.eu/art-17-gdpr/ And previous HN discussions: https://news.ycombinator.com/item?id=16366050

Yes and no. PII needs to be removed. The rest of the data needs to be anonymized. Right?

Re: Instead of deleting account, NYT appends ‘1000’ to username and email address

#95
post #64

Doing real deletes on user accounts is a surprisingly challenging problem and I'd be willing to bet very few companies do real deletes where all of your data is wiped permanently from the company. For legal and financial reasons, companies often need to keep track of historical user activity. If a company states in their investor quarterly report that they had 1M active users, they better be able to prove it in an au…

There is also a user-valuable reason to not do hard deletes. Doing a soft delete prevents another malicious user from immediately reclaiming your now-available ID and pretending to be you.

You can always hard delete all the data _and_ keep track of deleted users so that their usernames can't be reused.

Once you have hard delete, this solution is almost trivial and by far the most user-valuable.

Re: Instead of deleting account, NYT appends ‘1000’ to username and email address

#96

Netflix does that too. You can’t delete your account so they just append a string like “csr_morgan” in the domain so that your account is “deleted” (you can’t login anymore, because your email address technically doesn’t have an account anymore) and you can re-register with your email later if you wish. But I’d you use the altered email and the same password, everything is still there. Pretty sure this goes against G…

What happens when you re-register with the same email address and then later cancel again?

Re: Instead of deleting account, NYT appends ‘1000’ to username and email address

#97

Netflix does that too. You can’t delete your account so they just append a string like “csr_morgan” in the domain so that your account is “deleted” (you can’t login anymore, because your email address technically doesn’t have an account anymore) and you can re-register with your email later if you wish. But I’d you use the altered email and the same password, everything is still there. Pretty sure this goes against G…

What happens when you re-register with the same email address and then later cancel again?

I dont know... I'd be curious to find out but I honestly dont have the time or motivation to figure out their broken processes.

Re: Instead of deleting account, NYT appends ‘1000’ to username and email address

#98
post #95

Earlier quoted context omitted.

There is also a user-valuable reason to not do hard deletes. Doing a soft delete prevents another malicious user from immediately reclaiming your now-available ID and pretending to be you.

You can always hard delete all the data _and_ keep track of deleted users so that their usernames can't be reused. Once you have hard delete, this solution is almost trivial and by far the most user-valuable.

> keep track of deleted users so that their usernames can't be reused

This seems to violate GPDR, no? Attacker attempts to create an account (say: victim@gmail.com) on AshleyMadison and is prevented because the server tracked past users. Attacker could them demonstrate victim@gmail.com was at one point a user on AshleyMadison.com

Re: Instead of deleting account, NYT appends ‘1000’ to username and email address

#99
post #98
post #95

Earlier quoted context omitted.

You can always hard delete all the data _and_ keep track of deleted users so that their usernames can't be reused. Once you have hard delete, this solution is almost trivial and by far the most user-valuable.

> keep track of deleted users so that their usernames can't be reused This seems to violate GPDR, no? Attacker attempts to create an account (say: victim@gmail.com) on AshleyMadison and is prevented because the server tracked past users. Attacker could them demonstrate victim@gmail.com was at one point a user on AshleyMadison.com

That's not much different than not being able to create an account with victim@gmail.com because victim@gmail.com already has an account. Both instance leak information

Re: Instead of deleting account, NYT appends ‘1000’ to username and email address

#100
Is it also possible that since they have a subscription model, they have to build their system around people leaving and coming back?

I mean imagine if HBO had deleted accounts during GoT and Westworld instead is suspending them. How many people had a 9 month subscription per year for years at a time?

Post reply on HN