Sign an NDA for 100% Data Security.
Hide the confidential content of databases:
In most projects, IT companies give developers access to a test environment that contains a copy of their customer's database. In case you need to give your developer access to a database, but you prefer that some data remains invisible for your developer, Campion-Tech provides
(these SQL scriptst), which you can run on the target database to hide the confidential part of its contents.
Example:
After executing the script
(secure-odoo-12-entreprise-edition.sql), the emails of the customers will be replaced by the word "Client" concatenated with the identifier of the customer in the database concatenated with the word "@test-environment.com".
Before:
After:
In the same way
(these SQL scripts) edit any other contents of the database (phone, bank account , password, names, ....). So, you can download, edit and execute it depending on what you want to hide. In this way you can provide your developer with a test environment that is as close as possible to the production environment of your end customer, while preserving the confidentiality of your data.