News for hackers. Stuff that matters.
Re:Google Drive flags file only containing “1” for copyright... by ChicagoBoy11 on Monday January 24, 2022 @12:41PM (#30061041)
I experienced something similar building an internal tool on GSuite. I had a large file with sequences of 9 digit numbers specific to our use-case, all tied to names of people (employees). Whelp, at one point the tool I was working on stopped working, and it was flagged as apparently containing social security numbers (which I suppose matched the character length).

Whelp, on the admin panel, you can get a report of those files, and then mark it as a false positive. Which I did. But then nothing happened, and nothing changed. It was no use.

The hilarious bit: It did, of course, allow me to make a copy of the file in question, and then just point the resource I was building to the new file, which was exactly the same. Weeks later... so far, so good.

Re:Google Drive flags file only containing “1” for copyright... by spicybright on Monday January 24, 2022 @03:27PM (#30063538)
That's ridiculous. Storing social security numbers is necessary for lots of businesses.

Imagine your filing cabinet not letting you file employment forms with a SS# on them.

It's the sticky note password problem all over again...

Re:Google Drive flags file only containing “1” for copyright... by 015a on Monday January 24, 2022 @05:32PM (#30064979)
This isn't some default thing on G-Suite; its the DLP setting which enterprises can elect to toggle on, if they pay for the most expensive G-Suite plan. It also, afaik, only applies to shared files.

It does not work, in such a myriad of ways that I'd be blown away if it wasn't just some summer intern's project three years ago and it hasn't been touched since. But it does check boxes for audits. And enterprises don't care about actual security, they just want to check boxes for audits.

Re:Google Drive flags file only containing “1” for copyright... by spicybright on Monday January 24, 2022 @10:02PM (#30067374)
That actually changes the entire context of this. Sorry, I don't think I read closely enough to the source article.
Re:Google Drive flags file only containing “1” for copyright... by 015a on Tuesday January 25, 2022 @10:26AM (#30072820)
Oh to be clear, this has nothing to do with the original submission; that's a false-positive copyright issue which is global and probably applies to personal accounts as well as G-Suite. That cannot be turned off.

DLP (data loss prevention) is a different feature for enterprises, which is specifically related to the social security number thing. It "protects" (poorly) against leaking lots of different classes of data from GDrive, but it doesn't do copyright, and it is optionally enabled by enterprise IT for an organization.

Re:Google Drive flags file only containing “1” for copyright... by driverdan on Monday January 24, 2022 @03:46PM (#30063787)
> That's ridiculous. Storing social security numbers is necessary for lots of businesses.

They should absolutely not be stored in a GSuite document. SSNs should be treated more securely than credit card numbers.

Re:Google Drive flags file only containing “1” for copyright... by spicybright on Monday January 24, 2022 @04:06PM (#30064030)
Should, yes, but in practice not really. I'm talking more about employee information.

You need it for tax forms, background checks, citizenship queries, sometimes bank information, etc.

So your options are:

1. Store them locally on a computer. Typically on some old windows 7 machine in the corner that hasn't been updated in some time.

2. Store documents physically. Which will either be scanned onto random computers belonging to whoever needs them to be sent through probably insecure mail servers.

Or worse, your boss taking a picture of your form and sending it to people that way, leaving the form on their phone.

3. Some other online storage like whatever M$ is offering

4. Use google and somehow store SS#'s somewhere less secure, or obfuscate them in a way no one but a few people will understand and hope they don't block any other files you upload.

Businesses have been deciding how to manage these things since the start that work best for them. Having google force you into procedures that might not work for your use case is annoying at best. And they obviously don't know best if they have issues like in OP's post.

It's like they take away your gun so you can't shoot yourself in the foot, then fires it at things it thinks are problems hoping not to hit your feet.

And what's a few toes to a company the size of google?

Re:Google Drive flags file only containing “1” for copyright... by IYasha on Tuesday January 25, 2022 @09:52AM (#30072365)
If using public storage is absolutely unavoidable, I train people to use password-protected archives like rar or 7z. This way the content won't be indexed and less likely to be used by attackers.
Re:Google Drive flags file only containing “1” for copyright... by madaxe_again on Monday January 24, 2022 @04:58PM (#30064639)
Why? You can figure out someone’s SSN if you know where they’re from and what their birthday is. They’re highly predictable - particularly given that you’ll often see the last four digits as the “obfuscated” version in lists etc, and the first three are state, and the next two are based on when they were born. Put the two together, and job done. They’re effectively public data. The fact that they’re used as a magic security number/identifier is frankly mind-boggling.

Citation: https://www.pnas.org/content/106/27/10975

Re:Google Drive flags file only containing “1” for copyright... by spicybright on Monday January 24, 2022 @06:41PM (#30065765)
Uhg, I wish I didn't know this lol
Re:Google Drive flags file only containing “1” for copyright... by bonzini on Monday January 24, 2022 @04:02PM (#30063984)
Which is a problem of its own, since they're effectively usernames.

Secure usernames that have no corresponding password is already an oxymoron; that's what credit card numbers used to be, hence the introduction of the CVV, 3DSecure and so on; but at least a credit card can be blocked with relative ease. But SSNs are secure unchangeable usernames, which makes even less sense.

Do any countries other than the US have such an abomination, where you can figure out the SSN of someone and ruin their life?

Re:Google Drive flags file only containing “1” for copyright... by AnthonyMouse on Monday January 24, 2022 @04:55PM (#30064606)
You can actually change your social security number in the circumstance of "victim of identity theft continues to be disadvantaged by using the original number":

https://faq.ssa.gov/en-us/Topic/article/KA-02220

It's a huge pain, obviously. Especially when you get to all the systems which blindly assume it isn't possible. But you can do it.

They ought to just open it up and let anyone who requests to change it once a year no questions asked.

Re:Google Drive flags file only containing “1” for copyright... by bonzini on Tuesday January 25, 2022 @12:40AM (#30068530)
Doesn't it reset your credit history? (Which you reluctantly want if you were the victim of identity theft, but not yearly)
Re:Google Drive flags file only containing “1” for copyright... by tempestn on Monday January 24, 2022 @07:58PM (#30066465)
Which would have the benefit of forcing those systems to be updated. Agreed.
Re:Google Drive flags file only containing “1” for copyright... by spicybright on Monday January 24, 2022 @04:07PM (#30064046)
Not that I know of. It really is a horrible system. But it's not one I want Google trying to solve.
Re:Google Drive flags file only containing “1” for copyright... by C19is20 on Monday January 24, 2022 @05:31PM (#30064967)
Italy: https://ilmiocf.it lets you generate your equivalent of an ssn (fiscal code). And, yes...if you know someone's very basic details you have the number.

For US viewers, enter 'stati uniti' as 'comune di nascita'.

Use deepl.com for the bit at the bottom.

Re:Google Drive flags file only containing “1” for copyright... by azernik on Monday January 24, 2022 @07:15PM (#30066080)
Whereas in Israel, a national ID number is treated as just that - an ID number. You put it on every single contract you sign, on most bureaucratic forms, &c, and it's used to match up individual identity rather than names. On many online services, your ID number is your username, and your password is chosen per-service.
Re:Google Drive flags file only containing “1” for copyright... by bonzini on Tuesday January 25, 2022 @12:35AM (#30068504)
It's the same in Italy, actually. The poster above is incorrect.
Re:Google Drive flags file only containing “1” for copyright... by bonzini on Tuesday January 25, 2022 @12:34AM (#30068497)
Why is it always Italians shitting on the country without knowing what they're talking about? This is absolutely not comparable. You can't ruin someone's life if you have their codice fiscale (source: am Italian).

Most countries do have some kind of id number like that, but they always have a "password" too. In Italy authentication is done by the SPID providers[1] or with an electronic id card (or physically with an id card, driving license or passport).

You can't get a credit card and spend as much as you want in their name. You need at least a stolen or counterfeit physical document to open a bank account, or a stolen password and a SPID second factor to file a fraudulent tax return. In the US the SSN is often enough unless you opt into freezing credit.

[1] for non Italians, that's the acronym for public digital identity system; it's a SAML-based authentication mechanism used by most public websites including tax returns, pension/welfare, and healthcare

Re:Google Drive flags file only containing “1” for copyright... by C19is20 on Saturday January 29, 2022 @02:09AM (#30124443)
Read again "Italy: https://ilmiocf.it lets you generate your equivalent of an ssn (fiscal code). And, yes...if you know someone's very basic details you have the number."

I did not say you can "ruin someone's life" with it. I very clearly wrote "if you know someone's very basic details you have the number". No more, no less.

If I knew the details of Milano Bonzini, born in Milano on 10/10/2010 then this is (probably) their codice: BNZMLN10R10F205U.

I thought the site would be __fun__ for foreigners (US, but not only) on HN, maybe if they have Italian heritage, they can work out nonna's number.

The "stampa codice a barre", is equally fun and I know several visitors that have printed it out to go with their holiday memories.

Re:Google Drive flags file only containing “1” for copyright... by jsymolon on Monday January 24, 2022 @04:38PM (#30064407)
> SSNs should be treated ...

As someone who dealt with identity theft, SSN should only be collected if contact with the SSA is needed. I.E. payment of social security benefits.

Any and ALL other "ID", nope. Use some other number.

Re:Google Drive flags file only containing “1” for copyright... by inetknght on Monday January 24, 2022 @04:52PM (#30064579)
> As someone who dealt with identity theft, SSN should only be collected if contact with the SSA is needed.

You wanna tell that to phone carriers, internet service providers, electricity providers, and even water providers?

Re:Google Drive flags file only containing “1” for copyright... by gzer0 on Monday January 24, 2022 @06:05PM (#30065367)
You are not legally required to provide your SSN to businesses or other entities, however, their policies may impact whether they choose to work with you.

So unfortunately... they will decline to do business with you if you decline to provide your SSN.

The only logical solution: Government needs to mandate a no SSN requirement and make it illegal to refuse service even if no SSN is provided.

Re:Google Drive flags file only containing “1” for copyright... by spicybright on Monday January 24, 2022 @04:47PM (#30064522)
I definitely agree, but in america it's impossible to be legally employed without your employer having your SS# on record.
Re:Google Drive flags file only containing “1” for copyright... by inetknght on Monday January 24, 2022 @04:53PM (#30064591)
Well, yes. Employers need to talk to the Social Security Administration regarding your social security withholdings...
Re:Google Drive flags file only containing “1” for copyright... by nybble41 on Monday January 24, 2022 @06:17PM (#30065510)
It's also your tax ID, unless you've filed for a separate one. While the original intent may have been that the SSN would only be used for Social Security, by now various places are required by law to collect your SSN even if they have nothing to do with the Social Security Administration. But that isn't even the real problem here. SSNs are an identifier (username). Merely knowing someone's SSN shouldn't grant you any extra privileges. It's not a secret—lots of people know it, and it isn't even hard to guess from age and birthplace—and yet people treat it as if it were something akin to a password, as if knowledge of a person's SSN were enough to establish identity. By this point in time we should very well know to use only zero-knowledge proofs for authentication and not even share the secret with the entity one is authenticating to, so they can't turn around and impersonate you to someone else.

The same goes for credit card and bank account numbers. As anyone you've ever paid with your card or by check has access to these they can't be considered particularly secret. The problem is that the system barely has any authentication built in. 4-digit PINs and hastily handwritten signatures only an expert can verify do not offer reasonable security. Chip cards are a bit better (non-clonable, require physical possession) but only work for in-person transactions.

Re:Google Drive flags file only containing “1” for copyright... by AnthonyMouse on Monday January 24, 2022 @04:49PM (#30064555)
You say things that are true, and yet they are inconsistent with existing practice. Is there a word for this?
Re:Google Drive flags file only containing “1” for copyright... by aspenmayer on Monday January 24, 2022 @04:56PM (#30064620)
Re:Google Drive flags file only containing “1” for copyright... by ldoughty on Monday January 24, 2022 @04:50PM (#30064563)
"I'm sorry, we can't put you in the system without it.. it wont let us"....

I always omit SSN, but often can't get away with it.

Re:Google Drive flags file only containing “1” for copyright... by panarky on Monday January 24, 2022 @05:04PM (#30064694)
My dentist said I couldn't leave the SSN field blank so I filled in 867-53-0909.
Re:Google Drive flags file only containing “1” for copyright... by amatecha on Monday January 24, 2022 @07:37PM (#30066294)
It always surprises me how many signup forms on the web require a phone number but still accept a "555" prefix :) If you're not familiar: https://en.wikipedia.org/wiki/555_(telephone_number)
Re:Google Drive flags file only containing “1” for copyright... by nathanaldensr on Monday January 24, 2022 @04:57PM (#30064624)
Thanks to Equifax, SSNs are effectively public anyway.
Re:Google Drive flags file only containing “1” for copyright... by bob1029 on Monday January 24, 2022 @05:31PM (#30064966)
> SSNs should be treated more securely than credit card numbers.

I disagree. Both SSNs and credit card numbers should be treated with equal consideration.

Establishing arbitrary classes of PII protection based upon perceived severity of compromise is a bad strategy. In the market we work in, you either get this 100% right or you don't get it right at all. There is no happy middle-ground when you are selling software to banks or other such organizations. No one is interested in "mostly" correct when it comes to PII they are responsible for protecting.

Re:Google Drive flags file only containing “1” for copyright... by vidarh on Monday January 24, 2022 @05:25PM (#30064895)
Not just that, but official US government websites publish plenty of data with SSNs of dead people in them. For my genealogy research I have plenty of SSNs sitting around for relatives to emigrated to the US because they've happened to show up in searches.

E.g. here[1] is one of Ancestry's many catalogs based on US government data dumps that even allows you to explicitly search by SSN.

So even if one were to argue that SSNs of living people shouldn't be in GSuite, and there may be many good arguments for that, there are vast quantities of SSNs out there that are explicitly and openly shared by the government. If Google starts blocking me from accessing any of my files with notes about family history, I'll be pissed off.

I guess it's time to move off Google Docs too (I've largely left Gmail)

[1] https://www.ancestry.com/search/collections/60901/

Re:Google Drive flags file only containing “1” for copyright... by slig on Monday January 24, 2022 @01:32PM (#30061828)
Google is working very hard to make everyone drop their shitty services.
Re:Google Drive flags file only containing “1” for copyright... by kwhitefoot on Monday January 24, 2022 @12:56PM (#30061254)
Is this a tool that you pay money for? Sounds like it fails the 'fitness for purpose' test.
Re:Google Drive flags file only containing “1” for copyright... by Kim_Bruning on Monday January 24, 2022 @02:32PM (#30062711)
This is why running filters on automated data is never a good idea, and should never be accepted (at least for enterprise applications, but really for anything) .
Re:Google Drive flags file only containing “1” for copyright... by Arnavion on Monday January 24, 2022 @03:00PM (#30063146)
This is another case for only pushing encrypted files to storage hosts, unless it's against Google Drive's TOS or something. Has anyone tried it? Did Google complain?
Re:Google Drive flags file only containing “1” for copyright... by aspenmayer on Monday January 24, 2022 @05:06PM (#30064720)
If you don’t know about this feature of rclone, you’re in for a treat! Combined with unionfs or mergerfs, or the builtin union function, you can have cached local decrypted mounts of locally encrypted remote mounted directories on gdrive, mirrored to a local folder.

https://rclone.org/crypt/

https://rclone.org/union/

Edit: there is also the (sorta abandoned, or finished/complete depending on your pov) plexdrive project, which does a bit of Plex server specific opinionated stuff and mounts gdrive read only, but which may help with reducing API quota usage according to some reports. I’ve never had any issues with the quotas that I’m aware of, but I did have to tune my settings a fair bit to get it dialed in on a somewhat memory constrained vps.

https://github.com/plexdrive/plexdrive

Re:Google Drive flags file only containing “1” for copyright... by anon9001 on Monday January 24, 2022 @03:08PM (#30063258)
Tarsnap is entirely encrypted and the service provider can't see the keys. They run it on EC2 and S3: https://www.tarsnap.com/infrastructure.html
Re:Google Drive flags file only containing “1” for copyright... by xcjs on Monday January 24, 2022 @03:11PM (#30063318)
I have an Enterprise Gsuite account with 50 TB of encrypted data for around 5 years (this was of course prior to the rebranding). I've had no complaints from Google so far.
Re:Google Drive flags file only containing “1” for copyright... by aspenmayer on Monday January 24, 2022 @05:08PM (#30064743)
You use rclone, or another stack? I’m always trying new tools in this space.
Re:Google Drive flags file only containing “1” for copyright... by CPAhem on Monday January 24, 2022 @07:06PM (#30066002)
Syncdocs is also an easy end-to-end encryption/sync app for Google Drive

https://syncdocs.com

Re:Google Drive flags file only containing “1” for copyright... by Gigachad on Monday January 24, 2022 @07:29PM (#30066227)
Problem is it makes the apps / integrations useless. I use google drive primarily from my ipad and encrypted files would mean I can't just "save to files" and have it drop in to google drive.
Re:Google Drive flags file only containing “1” for copyright... by stevens37 on Monday January 24, 2022 @04:40PM (#30064428)
yes

openssl enc -e -aes-128-cbc -in ${1} -out ${1}.cr -iter +123456 -k <password>