Book Image

Oracle Database 12c Security Cookbook

By : Zoran Pavlovic, Maja Veselica
Book Image

Oracle Database 12c Security Cookbook

By: Zoran Pavlovic, Maja Veselica

Overview of this book

Businesses around the world are paying much greater attention toward database security than they ever have before. Not only does the current regulatory environment require tight security, particularly when dealing with sensitive and personal data, data is also arguably a company’s most valuable asset - why wouldn’t you want to protect it in a secure and reliable database? Oracle Database lets you do exactly that. It’s why it is one of the world’s leading databases – with a rich portfolio of features to protect data from contemporary vulnerabilities, it’s the go-to database for many organizations. Oracle Database 12c Security Cookbook helps DBAs, developers, and architects to better understand database security challenges. Let it guide you through the process of implementing appropriate security mechanisms, helping you to ensure you are taking proactive steps to keep your data safe. Featuring solutions for common security problems in the new Oracle Database 12c, with this book you can be confident about securing your database from a range of different threats and problems.
Table of Contents (18 chapters)
Oracle Database 12c Security Cookbook
Credits
About the Authors
About the Reviewers
www.PacktPub.com
Preface

Column encryption - creating new table that has encrypted column(s)


In this recipe, you're going to learn to use TDE column encryption to encrypt columns in a newly created table.

Getting ready

It is assumed that a keystore is opened and a master key is created.

How to do it...

  1. Connect to the database as a user who has administer key privilege or SYSKM privilege (for example, maja):

    $ sqlplus maja
    
  2. Create a new table (for example, table enc_cols in schema hr) 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

    Figure 11 - A syntax to create the table hr.enc_cols

  3. Connect to the database as a user who can insert and view data in the table (for example, hr user):

    SQL> connect hr
    
  4. Insert several arbitrary values into the table HR.ENC_COLS.

    Figure 12 - Test values

  5. Verify that the user can view unencrypted values in all columns.

    Figure 13- Encryption is transparent

  6. Connect...