Do developers in your company have access to all data?

Question

Work organization

Consider the situation. A new developer comes to work. He needs to set up a fully working local database. To make the code work and have something to test it on.
What are you doing? In my opinion, there are three options:
1. Give him a dump from the production server, which may contain customer data, some other sensitive things, like private messages.
2. A database filled with completely random data.
3. Dump from the production server, but in which emails, invoices, personal messages, etc. filled with random values.
Which option is used in your company?

Answer 1

There is a fourth option - a test database with specially generated data. Somewhere I saw such generators, for example Benerator

Answer 2

I use the third one, because it's just fast and takes me 5 minutes, and generating data myself is sometimes very dreary, especially if there are 200 tables in the database.

Answer 3

Use fixtures.