1/12

Contents

List of Figures

List of Tables

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions

Changes in This Release for Oracle Data Masking and Subsetting User’s Guide

• Versioning of Oracle Data Masking and Subsetting
• Changes in Oracle Data Masking and Subsetting Release 13.2
  • Enhanced Support for Discovering Non-Dictionary Based Referential Relationships
  • Support for Handling Object Names With Size up to 128 Bytes
  • Support for Importing and Exporting the Complete Database
  • Support for Retaining the Existing Schema While Importing the Subset Dump
• Changes in Oracle Data Masking and Subsetting Release 13.1
  • Support for Non-Dictionary Based Referential Relationships (Application Defined Relationships)
  • Subset Data Based on Table Partitions
  • Support for Application Data Modeling and Data Masking of Edition View Objects

1 Introduction to Oracle Data Masking and Subsetting

• The Need to Mask and Subset Data
• Challenges Organization Face for Masking and Subsetting Data
• How Oracle Data Masking and Subsetting Addresses Masking/Subsetting Challenge
• Major Components of Oracle Data Masking and Subsetting
  • Application Data Modeling
  • Data Masking Format Library
  • Data Masking Transformations
  • Data Subsetting
  • Integrated Masking and Subsetting
• Architecture
• Deployment Options
• Methodology
• Outline of Steps to Mask and Subset Data

2 Before You Begin

• Privileges and Roles
• Oracle Data Masking and Subsetting Access Rights
• Access Control For Oracle Data Masking and Subsetting Objects
• Storage Requirements
• Supported Data Types
• Unsupported Objects

3 Application Data Modeling

• Creating an Application Data Model
  • Creating an ADM
  • Editing an ADM to View the Application Schemas and Tables
  • Adding and Removing Tables From the Application Schema
  • Viewing the Referential Relationships
  • Adding and Removing Referential Relationships
  • Performing Sensitive Data Discovery
    • Viewing the Discovery Results
    • Setting Sensitive Status on the Discovery Results
    • Adding and Removing Sensitive Columns
• Creating and Managing Custom Sensitive Column Types
• Associating a Database to an Existing ADM
• Verifying or Synchronizing an ADM
• Importing and Exporting an ADM
  • Importing an ADM
    • Importing an ADM XML File from your Desktop
    • Importing an ADM XML file from the Software Library
  • Exporting an ADM
    • Exporting an ADM as an XML File to Your Desktop
    • Exporting an ADM
    • Exporting an ADM to a Transparent Sensitive Data Protection Catalog
• Assigning Privileges to an Existing ADM

4 Data Masking

• Overview of Oracle Data Masking
  • Data Masking Concepts
  • Roles of Data Masking Users
  • Related Oracle Security Offerings
  • Agent Compatibility for Data Masking
• Format Libraries and Masking Definitions
• Recommended Data Masking Workflow
• Data Masking Task Sequence
• Defining Masking Formats
  • Creating New Masking Formats
    • Providing User-Defined and Post-Processing Functions
    • Using Masking Format Templates
  • Using Oracle-supplied Predefined Masking Formats
    • Patterns of Format Definitions
    • Category Definitions
      • Credit Card Numbers
      • United States Social Security Numbers
      • ISBN Numbers
      • UPC Numbers
      • Canadian Social Insurance Numbers
      • North American Phone Numbers
      • UK National Insurance Numbers
      • Auto Mask
    • Installing the DM_FMTLIB Package
  • Providing a Masking Format to Define a Column
  • Deterministic Masking Using the Substitute Format
• Masking with an Application Data Model and Workloads
  • Editing a Data Masking Definition
  • Adding Columns for Masking
  • Selecting Data Masking Advanced Options
    • Data Masking Options
    • Random Number Generation
    • Pre- and Post-mask Scripts
  • Scheduling a Script Generation Job
  • Scheduling a Data Masking Job
  • Estimating Space Requirements for Masking Operations
  • Adding Dependent Columns
  • Masking Dependent Columns for Packaged Applications
  • Importing a Data Masking Template
  • Cloning the Production Database
• Masking a Test System to Evaluate Performance
  • Using Only Masking for Evaluation
  • Using Cloning and Masking for Evaluation
• Upgrade Considerations
• Using the Shuffle Format
• Using Group Shuffle
• Using Conditional Masking
• Using Data Masking with LONG Columns
• Debugging a Data Masking Job

5 Data Subsetting

• Creating a Data Subset Definition
  • Generating a Subset Script
  • Saving a Subset Script
• Importing and Exporting Subset Templates and Dumps
  • Importing a Subset Definition
    • Importing a Subset Definition XML File From Your Desktop
    • Importing a Subset Dump
    • Importing a Subset Definition XML File From the Software Library
  • Exporting a Subset Definition
    • Exporting a Subset Definition as an XML File to Your Desktop
    • Exporting a Subset Definition From the Software Library
• Creating a Subset Version of a Target Database
• Synchronizing a Subset Definition with an Application Data Model
• Granting Privileges on a Subset Definition
• About Inline Masking and Subsetting
• Inline Masking and Subsetting Scenarios
  • Masking and Exporting Production Data
  • Masking and Deleting Operations on a Test Database
  • Masking Sensitive Data and Exporting a Subset of a Production Database
  • Performing Subset, Mask, and Delete Operations on a Test Database
  • Applying Column Rules
  • Exporting a Subset Definition That Uses Inline Masking
  • Importing a Subset Definition That Uses Inline Masking
  • Importing a Subset Dump
  • Saving a Subset Script Bundle
• Lifecycle Management

Index