Decrypt a Column

Prerequisite

Before decrypting a column, the Migration Server should be up and running, else, an error will be thrown.

Steps

To decrypt column:

1. Log on to the CipherTrust Manager GUI.

2. Click Database Protection to open the application. The Databases screen displays the list of existing database connections, if any.

3. Click the desired database connection.

4. Click the Tables link.

5. On the Authorize Database screen, enter the Database Password to access the tables.

6. Under the Tables with Encrypted Columns section, click the desired table. The list of columns is displayed.

7. Click Decrypt. The Decrypt < table name > wizard is displayed. Follow the steps to complete the setup.

   a. Column Info

   b. Add Data Settings

   c. Preview SQL

   c. Perform Operation

Column Info

1. From the available options, select the column to be decrypted.

2. Click Next.

Add Data Settings

1. Enter the Batch Size in which you want to decrypt the data.

2. Click Next.

Review

1. If you want to modify any detail such as Column Info and Data Settings, click Edit, update the fields, and click Next.

2. Click Next.

Perform Operation

The Perform Operation screen shows the progress of the operation. A message The column decrypted successfully. Close the window to return to the list is displayed on the screen. Click Close to exit the wizard.