Skip to Main Content
Oracle PL/SQL for DBAs
book

Oracle PL/SQL for DBAs

by Arup Nanda, Steven Feuerstein
October 2005
Intermediate to advanced content levelIntermediate to advanced
454 pages
14h 44m
English
O'Reilly Media, Inc.
Content preview from Oracle PL/SQL for DBAs

Chapter 4. Data Encryption and Hashing

In the simplest terms, encryption means disguising data, or altering the contents in such a way that only the creator of the original data knows the secret of how to put the data back together again. This chapter describes Oracle’s support for encryption, focusing on the concepts and features of most use to DBAs. The emphasis here is on the use of Oracle’s built-in packages, DBMS_CRYPTO (available in releases from Oracle Database 10g Release 1 onward) and DBMS_OBFUSCATION_TOOLKIT (used primarily with earlier releases). I’ll also focus on the protection of data on disk, as opposed to the protection of data being transmitted between the client and the database or the protection of data during authentication, both of which require the use of Oracle’s extra-cost Advanced Security Option (ASO) . The only exception to the rule is transmission of passwords, which are always encrypted, regardless of the use of ASO.

In this chapter, you will learn how to build a basic encryption system that will protect sensitive data from access by unauthorized users. You will learn how to build a key management system that effectively protects your encryption keys while seamlessly providing the application users unrestrained access to the data. You’ll also learn about cryptographic hashing and the use of Message Authentication Code (MAC). I’ll also describe Transparent Data Encryption (TDE), a new feature introduced in Oracle Database 10g Release 2 that can be used ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Oracle PL/SQL Best Practices

Oracle PL/SQL Best Practices

Steven Feuerstein
Expert Oracle PL/SQL

Expert Oracle PL/SQL

Ron Hardman, Michael McLaughlin
Oracle PL/SQL For Dummies

Oracle PL/SQL For Dummies

Michael Rosenblum, Paul Dorsey

Publisher Resources

ISBN: 0596005873Supplemental ContentErrata Page