Table of Contents
- List of Figures
- List of Tables
- Title and Copyright Information
- Preface
- Changes in This Release for Oracle Data Masking and Subsetting User’s Guide
- 1
Introduction to Oracle Data Masking and Subsetting
- 1.1 The Need to Mask and Subset Data
- 1.2 Challenges Organization Face for Masking and Subsetting Data
- 1.3 How Oracle Data Masking and Subsetting Addresses Masking/Subsetting Challenge
- 1.4 Major Components of Oracle Data Masking and Subsetting
- 1.5 Architecture
- 1.6 Deployment Options
- 1.7 Methodology
- 1.8 Outline of Steps to Mask and Subset Data
- 2 Before You Begin
- 3
Application Data Modeling
- 3.1 Creating an Application Data Model
- 3.2 Creating and Managing Custom Sensitive Column Types
- 3.3 Associating a Database to an Existing ADM
- 3.4 Verifying or Synchronizing an ADM
- 3.5 Importing and Exporting an ADM
- 3.6 Assigning Privileges to an Existing ADM
- 4
Data Masking
- 4.1 Overview of Oracle Data Masking
- 4.2 Format Libraries and Masking Definitions
- 4.3 Recommended Data Masking Workflow
- 4.4 Data Masking Task Sequence
- 4.5
Defining Masking Formats
- 4.5.1 Creating New Masking Formats
- 4.5.2 Using Oracle-supplied Predefined Masking Formats
- 4.5.3 Providing a Masking Format to Define a Column
- 4.5.4 Deterministic Masking Using the Substitute Format
- 4.6
Masking with an Application Data Model and Workloads
- 4.6.1 Editing a Data Masking Definition
- 4.6.2 Adding Columns for Masking
- 4.6.3 Selecting Data Masking Advanced Options
- 4.6.4 Scheduling a Script Generation Job
- 4.6.5 Scheduling a Data Masking Job
- 4.6.6 Estimating Space Requirements for Masking Operations
- 4.6.7 Adding Dependent Columns
- 4.6.8 Masking Dependent Columns for Packaged Applications
- 4.6.9 Importing a Data Masking Template
- 4.6.10 Cloning the Production Database
- 4.7 Masking a Test System to Evaluate Performance
- 4.8 Upgrade Considerations
- 4.9 Using the Shuffle Format
- 4.10 Using Group Shuffle
- 4.11 Using Conditional Masking
- 4.12 Using Data Masking with LONG Columns
- 4.13 Debugging a Data Masking Job
- 5
Data Subsetting
- 5.1 Creating a Data Subset Definition
- 5.2 Importing and Exporting Subset Templates and Dumps
- 5.3 Creating a Subset Version of a Target Database
- 5.4 Synchronizing a Subset Definition with an Application Data Model
- 5.5 Granting Privileges on a Subset Definition
- 5.6 About Inline Masking and Subsetting
- 5.7
Inline Masking and Subsetting Scenarios
- 5.7.1 Masking and Exporting Production Data
- 5.7.2 Masking and Deleting Operations on a Test Database
- 5.7.3 Masking Sensitive Data and Exporting a Subset of a Production Database
- 5.7.4 Performing Subset, Mask, and Delete Operations on a Test Database
- 5.7.5 Applying Column Rules
- 5.7.6 Exporting a Subset Definition That Uses Inline Masking
- 5.7.7 Importing a Subset Definition That Uses Inline Masking
- 5.7.8 Importing a Subset Dump
- 5.7.9 Saving a Subset Script Bundle
- 5.8 Lifecycle Management
- Index