OpenEdge SQL support for transparent data encryption

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 key store 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.

In this section:

Using the CREATE TABLE statement

Adding an encrypted column

Using the CREATE INDEX statement

Using the ALTER TABLE statement

Viewing encryption policy with the SHOW ENCRYPT statement

Deleting encrypted objects with OpenEdge SQL