Column encryption - adding new encrypted column to table

In this recipe, you'll add a new column, which will be encrypted using a nondefault encryption algorithm, to an existing table.

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 has administer key privilege or SYSKM privilege (for example, maja) and verify that the keystore is in the OPEN status. You should get the result similar to the one depicted in Figure 9:

   $ sqlplus maja
   

   

   Figure 9

2. Add a column (for example, bonus) to a table (for example, hr.employees), encrypted using the AES 256 algorithm.

   

   Figure 10 - Adding the new encrypted column to the table