In this recipe, you're going to learn to use TDE column encryption to encrypt columns in a newly created table.
Connect to the database as a user who has administer key privilege or
SYSKM
privilege (for example,maja
):$ sqlplus maja
Create a new table (for example, table
enc_cols
in schemahr
) that has, for example, the following structure:Column name
Column type
Encrypted
NAME
VARCHAR2
(50)No
CREDIT_LIMIT
NUMBER
(10)Yes, AES192
SALARY
NUMBER
(10)Yes, AES192
Connect to the database as a user who can insert and view data in the table (for example,
hr
user):SQL> connect hr
Insert several arbitrary values into the table
HR.ENC_COLS
.Verify that the user can view unencrypted values in all columns.
Connect...