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...
- 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 theOPEN
status. You should get the result similar to the one depicted in Figure 9:$ sqlplus maja
- Add a column (for example,
bonus
) to a table (for example,hr.employees
), encrypted using the AES 256 algorithm.
Get Oracle Database 12c Security Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.