1 Introduction to Oracle Data Masking and Subsetting

The Data Masking and Subsetting features of the Enterprise Manager for Oracle Database Plug-in help you to securely manage test data.

When performing real-world testing, there is the risk of exposing sensitive data to non-production users in a test environment. The test data management features of Oracle Database helps to minimize this risk by enabling you to perform data masking and data subsetting on the test data.

When production data is copied into a testing environment, there is the risk of breaching sensitive information to non-production users, such as application developers or external consultants. In order to perform real-world testing, these non-production users need to access some of the original data, but not all the data, especially when the information is deemed confidential.

Oracle Database offers test data management features that help reduce this risk by enabling you to:

  • Store the list of applications, tables, and relationships between table columns using Application Data Modeling. See Chapter 2, "Application Data Modeling," for more information.

  • Replace sensitive data from your production system with fictitious data that can be used during testing using data masking. See Chapter 3, "Data Masking," for more information.

  • Replicate information that pertains only to a particular site using data subsetting. See Chapter 4, "Data Subsetting," for more information.

Note:

You must have the Oracle Data Masking and Subsetting Pack license to use these security features.