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. Import the data into a new database.
2. Download the script and execute the command upon the Codebeamer version:
◦ The script: obfuscate_data_oracle.sql
◦ The command: sqlplus <username>/<password>@<SID> @<absolutePath>/obfuscate_data_oracle.sql
After executing the script, it is not possible to login to Codebeamer because all user credentials (usernames, passwords) are removed.
To set 007 as password for all users, run the following script:
UPDATE users
SET registrydate = null, passwd = LOWER(rawtohex(sys.dbms_crypto.hash(UTL_I18N.STRING_TO_RAW ('007'|| id ||'700101010000','AL32UTF8'), 6)));
SET registrydate = null, passwd = LOWER(rawtohex(sys.dbms_crypto.hash(UTL_I18N.STRING_TO_RAW ('007'|| id ||'700101010000','AL32UTF8'), 6)));
 |
If autocommit is not active in sqlplus, commit may be needed after the user password update:
|
commit;
Now it is possible login to Codebeamer with user-<user-id>/007. For example: user-1/007
|
|
LDAP/AD authentication must be disabled even if Fallback option is activated.
|