OpenEdge SQL Data Definition Language can be used to enable Transparent Data Encryption. This functionality provides only the DBA or security administrator, who also has keystore admin privileges, with the ability to:

  • Define encryption specifications for new tables, indexes, and LOB columns
  • Modify encryption or decryption specifications for existing tables, indexes, and LOB columns
  • Drop existing encrypted tables, indexes, and LOB columns
  • View encryption specifications for tables, indexes, and LOB columns
  • Rekey existing encrypted tables, indexes, and LOB columns

Note that the tables, indexes, and LOB columns must be in a Type II storage area.