MAINTAIN COLUMN ENCRYPTION#
This screen lists the columns that may be encrypted in one of two columns. If the data is presently unencrypted, then it will be shown in the left (Unencrypted) column. Those in the right column (Encrypted) have already been encrypted.
To encrypt all data in a specific database column, select the field name on the left side of the screen, and press the ENCRYPT button on the bottom of the screen. This will then go through the entire table, and encrypt the data in that field. This means that the existing field will be blanked out, and the data will be encrypted into the RAW version of that same field.
To decrypt all data in a specific database column, select the field name on the right side of the screen, and press the DECRYPT button on the bottom of the screen. This will then go through the entire table, and decrypt the data in that field. This means that the actual database field will be re-instated with clear-text data and the RAW (encrypted) version will be set to NULL.
Important Note#
- After you finish encrypting/decrypting data with the IMCE screen, you must restart the application server deployment in order to pick up the changes.
- The CHANGE_DATE and CHANGE_USER values on the tables affected will be updated with the IMCE user, and time the process updated the record.
