Try OpenEdge Now
skip to main content
Database Administration
Protecting Your Data : Transparent Data Encryption : OpenEdge SQL support for Transparent Data Encryption
 

OpenEdge SQL support for Transparent Data Encryption

OpenEdge SQL Data Definition Language supports Transparent Data Encryption. The new functionality provides only the DBA or security administrator 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. For details on the modified SQL syntax, see OpenEdge Data Management: SQL Development and OpenEdge Data Management: SQL Reference.