1/12

Contents

List of Figures

List of Tables

Title and Copyright Information

Preface

• Audience
• 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.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
• Changes in Oracle Data Masking and Subsetting Release 12.1
  • Support for Secure Shell Key-based Host Authentication
  • Support for Data Masking and Subsetting in Oracle Cloud

1 Introduction to Oracle Data Masking and Subsetting

• The Need to Mask and Subset Data
• Components
  • Application Data Modeling
  • Data Masking Format Library
  • Data Masking Transformations
  • Data Subsetting Techniques
  • Application Templates
• Architecture
• Execution Methods
  • In-Database
  • In-Export
  • Heterogeneous
• Methodology
• Workflow

2 Before You Begin

• Oracle Data Masking and Subsetting Access Rights
• Access Control Needed For DMS Objects
• Storage Requirements
  • Security and Regulatory Compliance
• 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
  • Exporting an ADM
• Assigning Privileges to an Existing ADM

4 Data Masking

• Overview of Oracle Data Masking
  • Data Masking Concepts
  • Security and Regulatory Compliance
  • 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
  • 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

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
  • Exporting a Subset Definition
• 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
• Lifecycle Management

Index