O'Reilly logo

Effective Oracle Database 10g Security by Design by David Knox

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Appendix BDATA_CRYPTO Package

The DBMS_CRYPTO package provides a comprehensive set of procedures and functions that will allow you to encrypt and decrypt data in the confines of the database. For most of the basic data types, such as VARCHAR2, dates, and numbers, you’ll have to convert the data to a RAW prior to invoking the DBMS_ CRYPTO package. CLOB and BLOB encryption is natively supported but only through procedures. Also, the encryption key used must be a RAW and has to be the appropriate size for the encryption algorithm you’ll be using.

These are facts and not criticisms. The DBMS_CRYPTO package is implemented effectively and these requirements are, at most, inconvenient. Chapter 13 discusses relevant issues, such as storing encrypted ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required