Column encryption is transparent and is done at the DBMS Server level. The Vector server handles encryption for the application and assures that data at rest is encrypted.

To use transparent column encryption, use the CREATE TABLE statement to encrypt column values and define the encryption passphrase. To enable access to the table, use the MODIFY statement.

The passphrase applies to all encrypted rows and columns in the table.