Obfuscate Sensitive Data
 |
The following process modifies the data in the database, and it is not possible to revert modifications. Do not use it on production environment!
|
1. Create a copy of the Codebeamer system to be obfuscated, if necessary.
2. Stop the Codebeamer test instance.
3. Run the following script against the test database obfuscate_data_postgres.sql. The following command can be used:
psql -U <user> -h <host> -p <port> -d <your_db> -f ./obfuscate_data_postgres.sql
4. Dump the obfuscated database as described above.
Check the Obfuscated Database
1. After executing the script, it is not possible to login to Codebeamer because all user credentials (usernames and passwords) are removed.
◦ Log in to the postgresql and execute the following commands to set all user password to 007:
▪ create extension pgcrypto;
▪ execute the following SQL command:
update users set registrydate=null, passwd=encode(digest(concat('007', id, '700101010000'), 'sha512'), 'hex');
2. Delete the directories under /repository/docs.
3. Start Codebeamer.
4. Login to Codebeamer with user-<user-id>/007. For example: user-1/007