Chapter 15 DBMS-Specific Features

Creating an encrypted table column

You can create one or more encrypted column in one or more tables. You can specify the encryption algorithm to be used, but all columns in a particular table must use the same algorithm. If you create a second encrypted column in a table, and specify a different algorithm, the last specified algorithm will be used for all columns in the table.

To encrypt a table column:

1. Create a column and open its property sheet.
2. On the General tab, specify any of the following types, which support encryption:
   
   
   • CHAR, NCHAR, VARCHAR2, and NVARCHAR2
   • DATE and TIMESTAMP
   • INTERVAL DAY TO SECOND and YEAR TO MONTH
   • NUMBER
   • RAW
3. Click the Oracle tab and select the Encryption checkbox.
4. Select an encryption algorithm from the list particular
5. [optional] Select the With salt checkbox in order to add some random bits to the encryption key.
6. Click OK to complete the column definition.

Copyright (C) 2007. Sybase Inc. All rights reserved.