Oracle Data Masking

Commvault software has industry-standard data-masking strategies for Oracle database table columns. Use data masking when you want to hide sensitive data in a non-production environment, such as a test or development system.

To use data masking, create data-masking policies for Oracle instances that contain the following information:

  • The database schema

  • The table columns to mask

  • The data masking type to use for the table column. The data masking types that are available depend on the column data type. For example, if the data type is "Date", then you can use the shuffling masking type.

The Commvault software automatically applies the data-masking policies when you perform the following operations:

  • Clone a database

  • Duplicate a database

  • Perform an out-of-place restore, for example to a new destination client

  • Manually run a data masking job on the database

The Commvault software provides different data-masking strategies based on the type of data that you want to mask.

Data Type

Available Masking Types

Character

  • Shuffling

  • Format-preserving

  • Fixed String

Number

  • Shuffling

  • Numeric Range

  • Numeric Variance

Date, Raw, Timestamp

Shuffling

Primary key

Foreign key

Decimal type column

  • Format-preserving

  • Shuffling

Data Masking Types

Shuffling

Shuffling applies to all data types. Shuffling takes values from multiple rows in a block (up to 2000 rows) and exchanges the values for the same field by using the Fisher-Yates algorithm.You can use this method for all data types, but we recommend that you do not use it for primary key or foreign key fields because it affects the table relationships.

Format-Preserving Encryption

If you use format-preserving encryption, then the masked output is the same length and format as the input, for example the masked output of a 20-character user name is a 20 character field.

Fixed String

Fixed string applies to character strings and replaces the original string with a random string that you specify when you configure a policy.

Numeric Range

Numeric range generates a random number between a minimum and maximum value that you specify when you configure a policy. We recommend that you do not use it for primary key or foreign key fields because it affects the table relationships.

Numeric Variance

Numeric variance takes the initial value and varies it by the percent that you specify when you configure a policy. We recommend that you do not use it for primary key or foreign key fields because it affects the table relationships.

Loading...