1/9
Contents
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 12.1
1
Introduction to Oracle Data Masking and Subsetting
2
Application Data Modeling
2.1
Creating an Application Data Model
2.2
Managing Sensitive Column Types
2.3
Associating a Database to an Application Data Model
2.4
Importing and Exporting an Application Data Model
2.4.1
Importing an ADM
2.4.2
Exporting an ADM
2.5
Verifying or Upgrading a Source Database
2.6
Using Self Update to Download the Latest Data Masking and Subsetting Templates
2.7
Access Rights to Data Security Objects
2.8
Granting Privileges on an Application Data Model
3
Data Masking
3.1
Overview of Oracle Data Masking
3.1.1
Data Masking Concepts
3.1.2
Security and Regulatory Compliance
3.1.3
Roles of Data Masking Users
3.1.4
Related Oracle Security Offerings
3.1.5
Agent Compatibility for Data Masking
3.1.6
Supported Data Types
3.2
Format Libraries and Masking Definitions
3.3
Recommended Data Masking Workflow
3.4
Data Masking Task Sequence
3.5
Defining Data Masking Formats
3.5.1
Creating New Data Masking Formats
3.5.1.1
Providing User-defined and Post-processing Functions
3.5.1.2
Using Data Masking Format Templates
3.5.2
Using Oracle-supplied Predefined Data Masking Formats
3.5.2.1
Patterns of Format Definitions
3.5.2.2
Category Definitions
3.5.2.2.1
Credit Card Numbers
3.5.2.2.2
United States Social Security Numbers
3.5.2.2.3
ISBN Numbers
3.5.2.2.4
UPC Numbers
3.5.2.2.5
Canadian Social Insurance Numbers
3.5.2.2.6
North American Phone Numbers
3.5.2.2.7
UK National Insurance Numbers
3.5.2.2.8
Auto Mask
3.5.2.3
Installing the DM_FMTLIB Package
3.5.3
Providing a Data Masking Format to Define a Column
3.5.4
Deterministic Masking Using the Substitute Format
3.6
Masking with an Application Data Model and Workloads
3.6.1
Adding Columns for Masking
3.6.2
Selecting Data Masking Advanced Options
3.6.2.1
Data Masking Options
3.6.2.2
Random Number Generation
3.6.2.3
Pre- and Post-mask Scripts
3.6.3
Scheduling a Script Generation Job
3.6.4
Scheduling a Data Masking Job
3.6.5
Estimating Space Requirements for Masking Operations
3.6.6
On Adding Dependent Columns
3.6.7
Masking Dependent Columns for Packaged Applications
3.6.8
Cloning the Production Database
3.6.9
Importing and Exporting a Data Masking Definition
3.6.9.1
Importing a Previously Exported Masking Definition
3.6.9.2
Importing a Data Masking Template from the Software Library
3.7
Masking a Test System to Evaluate Performance
3.7.1
Using Only Masking for Evaluation
3.7.2
Using Cloning and Masking for Evaluation
3.8
Upgrade Considerations
3.9
Using the Shuffle Format
3.10
Using Group Shuffle
3.11
Using Conditional Masking
3.12
Using Data Masking with LONG Columns
4
Data Subsetting
4.1
Creating a Data Subsetting Definition
4.1.1
Generating a Subset
4.1.2
Saving a Subset Script
4.2
Importing and Exporting Subset Templates and Dumps
4.2.1
Importing a Subsetting Definition
4.2.2
Exporting a Subsetting Definition
4.3
Creating a Subset Version of a Target Database
4.4
Synchronizing a Subsetting Definition with an Application Data Model
4.5
Granting Privileges on a Subsetting Definition
4.6
About Integrated Subset and Mask
4.7
Integrated Subset and Mask Scenarios
4.7.1
Mask and Export Production Data
4.7.2
Mask and Delete Operation on a Test Database
4.7.3
Mask Sensitive Data and Export a Subset of a Production Database
4.7.4
Perform Subset, Mask, and Delete Operations on a Test Database
4.7.5
Apply Column Mask Rules
4.7.6
Export a Subsetting Definition That Uses Integrated Subset and Mask
4.7.7
Import a Subsetting Definition That Uses Integrated Subset and Mask
4.7.8
Import a Subset Dump
4.7.9
Save Subset Script Bundle
Index
Scripting on this page enhances content navigation, but does not change the content in any way.