Encrypt Data Stored on Oracle Database
So far, we have encrypted data as it traversed the network between the client and the Oracle database. We have also encrypted data while in memory, but not in use on the client (the list of connection strings.) However, we have stored data on the Oracle database in clear text. In particular, we are concerned for the connection string lists that we have stored on Oracle in clear text. Well, we are going to address that concern here.
DBMS_CRYPTO Package
Oracle database provides a PL/SQL package that can assist us in doing data encryption at rest (while data is in storage in the database). By using the DBMS_CRYPTO package, we can selectively encrypt specific columns of data. Other alternatives exist, including ...
Get Expert Oracle and Java Security: Programming Secure Oracle Database Applications with Java 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.
