11 ms·
I'm really surprised that all engineers have free access to the Facebook database. That's really scary. I know at other organizations, with much less sensitiv
by kenjackson 16y ago
I'm really surprised that all engineers have free access to the Facebook database. That's really scary. I know at other organizations, with much less sensitive data, this stuff was under lock and key.
I have a hard time believing many aren't abusing this, just out of human nature ("did she mention me to any of her friends?").
- ssclafani 16y agoMultiple employees were fired for accessing private data in the past. I suspect that it is a serious taboo at the company now to even joke about it.
- pak 16y agoSo what you're saying is that now anybody can still do it, but everybody knows not to talk about it. I'm gathering that this will never change.
- hugh3 16y agoWhenever I meet anyone who works at facebook, my first instinct is to extricate myself from that conversation. Otherwise we might get to know each other, and become friends, and I'd never be sure that they weren't looking me up. My strategy for avoiding the prying eyes of facebook engineers is to be personally uninteresting to any facebook engineers. This might not work so well if I were a chick.
- kenjackson 16y agoThat seems way to risky to me. You basically have to watch server logs for some interesting patterns. And of course, if they're smart they simply oversubscribe in a query (or temporally space out a query), and then pinpoint the data they are looking for locally. Given they have 2000+ employees this is just a process that is looking to be constantly abused. I surely don't expect people aren't talking about it, but I'm nearly as confident that it is happening in a way that most people aren't aware of. No evidence, but again, I've seen people do worse, with less access.
- philjackson 16y agoI wonder how/if the access is restricted? Seems like a good compromise might be: * Read-only all the time. * Access through a special shell which logs your actions remotely. * Seemingly in keeping with the aggressive name & shame culture, if you join across all tables or forget a limit or something else which affects live operation, you get called out.
- kenjackson 16y agoBut if I'm clever I can space out queries a week or two, or a month or two (depending on what I'm looking for and how important it is). I'm fairly certain if you give me the schema, I can be very inconspicuous over a given amount of time.
- philjackson 16y agoYou mean for the privacy thing? Yea, I doubt it's impossible to stop altogether.
- deleted 16y ago[deleted]
- DougWebb 16y agoI imagine that the database is enormous and constantly changing, so it's probably impractical to have development copies that are sufficient to test your code against realistically. I'll bet Google engineers have access to their full database too for the same reason. On Reddit, someone mentioned that 'becoming someone', which I presume means making the software think you've logged in as that person, is unusual and must be justified and closely tracked when it happens. So I'm guessing that you can't just pull up records for some person from the database; you need to 'be' that person to get their data. The free access is probably just for stuff that is shared via the privacy controls.
- random42 16y ago> the database is enormous and constantly changing, so it's probably impractical to have development copies that are sufficient to test your code against realistically What the hell? why not?
- clojurerocks 16y agoConsidering they use mysql how feasible is it for the database to be constantly changing? I think ive read that they use it more as a key value store then a relational store but still.
- kingnothing 16y agoAs far as I know, Facebook uses Cassandra not MySQL.
- adrianbye 16y agowhat happens when one of those 1000 engineers decides to leak the FB database to wikileaks?
- deleted 16y ago[deleted]
- tortilla 16y agoLots of divorces and breakups. More media and public attention on the data than past leaks by wikileaks.
- didip 16y agoExtracting terabytes of data is difficult to go un-noticed. How do you transfer the data? rsync through external network is too slow. The most convenient way would be to mount physical drive on one of database server and copy things directly. But that would require cage access, which I assume not many employees have.
- yannk 16y agoThat's an excellent interview question! "How do you get the maximum of data out before getting noticed?". I guess the most effective way is to tamper with source code and smuggle data out along with legitimate traffic.
- didip 16y agoTampering the source code is an interesting idea. I think it cannot be the PHP code because that's peer-reviewed by 1000+ employees daily. It would have to be code rarely seen by others, e.g. Apache's mod_rewrite.
- khafra 16y agoOr you could simply produce a php version of a winning entry to the Underhanded C Contest: http://underhanded.xcott.com/ http://underhanded.xcott.com/
- bajsejohannes 16y agoMaybe governments have easier ways, but it sure seems like a good idea to have an employee working for you at facebook.
- blahedo 16y agoI think we can probably agree that if the access is available but carefully guarded, a clever and patient black-hat could make use of their access to get the data they want; but the white-hat who just wants to do their job gets blocked. While it's not the only valid choice, it strikes me as reasonable to just grant access and impress upon everyone the incredible responsibility they now have not to do unethical things.