News for hackers. Stuff that matters.
Re:Former employees say Lyft staffers spied on passengers by jacquesm on Thursday January 25, 2018 @09:37PM (#16236633)
I sincerely hope that your approach becomes common enough that I will see it implemented in practice. Right now it is rather the opposite, plain text data flying around everywhere and at rest in test databases and backups is the norm. And if you are really unlucky you will find it on the laptops of developers in the form of a two week old copy of main database. And if you are even more unlucky that developer does not have his hard drive encrypted and takes the bus every day to work. And already lost another laptop, just like that one, only nothing ever came of it so the data is most likely still safe.
Re:Former employees say Lyft staffers spied on passengers by crdb on Thursday January 25, 2018 @10:51PM (#16236918)
A database would already provide a layer of security (most people, including many "professionals", would not know what to do with it).

Customer data is often stored in a large, denormalised table in an Excel file called "customers" which contains the entire set of customers past and present, including those who unsubscribed or have not ordered for years, with all attributes (phone, address, etc.).

There is also no oversight on who has access to this file, since "marketing needs it for Facebook" or "customer service needs it for returns" or whatever the excuse du jour is. Even the newly hired intern with a stronger than usual interest in every system's credentials gets a copy.

You get some measure of security when there are more than one million customers and they need to start partitioning.

The most secure setup I've seen was a company whose entire repairs department ran on paper slips. Since nobody had the time or inclination to enter the information somewhere digital, no internal staff knew how to find customer information, even if they walked to the shop floor. I think a couple of old timers knew how to navigate the pile of slips and were the de facto DBMS engine.