[FINERACT-308] encrypt values in tenant_server_connections

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Auto Closed
• Component/s: System
• Labels: Cleanup2022 security
• Assignee: Unassigned
• Reporter: thynn win
• Created: 15/Dec/16 22:28
• Updated: 07/Nov/22 18:11
• Resolved: 07/Nov/22 18:11

Description

During the technical training held in Dec 2016, we learned one reason for using plain text in tenant_server_connections is the need to decrypt and hash is irreversible.

From Oracle we knew something builtin encryption functions exist like des3encrypt/decrypt and found similar function for mySQL. https://dev.mysql.com/doc/refman/5.5/en/encryption-functions.html

It'd be really great if you could encrypt the values in this table.