Oracle Database 12c Security Cookbook

Column encryption - encrypting existing column

It is common case that organizations first create database and later decide that they want to implement encryption. In this recipe, you're going to encrypt an existing column using TDE column encryption.

Getting ready

It is assumed that a keystore is opened and a master key is created.

How to do it...

1. Connect to the database as a user who can read data from the OE.CUSTOMERS table (for example, the oe user):

   $ sqlplus oe
   

2. Select data from column you want to encrypt (for example, cust_email), just to verify that the user can view it.
   

   Figure 18 - A test query

3. Connect to the database as a user who has administer ...