I posted this on the 8 forum as well. We have this DB on both 7 and 8 servers.-------
We’re in a big jam with one of our HR databases. It contains sensitive employee data so some of its fields were encrypted when it was originally designed. The few people who require access to the encrypted fields must be given an encryption key to access the encrypted fields.
The problem is that no one who currently works here knows how to generate the encryption key. The person who designed the database and handled this task left the organization five years ago. (so much for good documentation) The other person who entered the data for the past eight years recently retired and we need to give her replacement access to the DB’s encrypted fields. So this is the first time we’ve run into this issue.
Two of our IT staff have encryption keys. Below is the text from email that gave them access. It appears from the text that it is programmed into the database but we can’t find anything in the design to do this.
…“Encryption key “FISkey” is attached. You may insert this key into your ID file by using the Actions menu “Accept Encryption Key…” option.”
I’d appreciate any advice.
Thanks in advance.
Greg