If this is the first time that you are creating a Data Redaction policy, then the Data Redaction: Set up for enabling column sensitive type discovery dialog box appears. You can delete an Oracle Data Redaction policy using Enterprise Manager Cloud Control.

Deleting an Oracle Data Redaction Policy Using Enterprise Manager.

When you create an Oracle Data Redaction policy, it is enabled by default.

Enabling or Disabling an Oracle Data Redaction Policy in Enterprise ManagerĪn Oracle Data Redaction policy is run at run time only if it is enabled.

You can find Oracle Data Redaction policy details such as whether the policy is enabled by using Enterprise Manager Cloud Control.

Viewing Oracle Data Redaction Policy Details Using Enterprise Manager.

You can edit an Oracle Data Redaction policy using Enterprise Manager Cloud Control.

Editing an Oracle Data Redaction Policy Using Enterprise Manager.

You can create an Oracle Data Redaction policy using Enterprise Manager Cloud Control.

Creating an Oracle Data Redaction Policy Using Enterprise Manager.

Use the Data Redaction page in Cloud Control to manage Oracle Data Redaction policies.

About Managing Oracle Data Redaction Policies Using Enterprise Manager.

Click OK to create and save the custom redaction format.

NONE if the format will be used to only test the definition of a redaction policy, and not redact any column data RANDOM if the format should redact data in a random manner, using randomly generated values Ensure that you provide the function attributes. REGEX if the format should redact data based on a regular expression. Ensure that you provide the function attributes, as well as the data type that you want to use the redaction format for. PARTIAL if the format should redact only a part of the column data. For Redaction Function, select as follows:įULL if the format should redact the entire column data.

Select the function that the format should use to redact the column data. If you want to map the redaction format to a particular sensitive column type (such that the created redaction format can be used to redact the data of a column that is associated with the sensitive column type), then select a value for Sensitive Column Type. You can manage Oracle Data Redaction policy expressions in Enterprise Manager Cloud Control. Managing Named Data Redaction Policy Expressions Using Enterprise Manager.You can create, edit, view, and delete Oracle Data Redaction policies in Enterprise Manager Cloud Control. Managing Oracle Data Redaction Policies Using Enterprise Manager.

Oracle Data Redaction provides redaction formats to be used directly within a redaction policy to redact data. Managing Oracle Data Redaction Formats Using Enterprise Manager.Management of Sensitive Column Types in Enterprise ManagerĪ sensitive column type categorizes table column sensitive information into a sensitive information type, such as credit card numbers.Oracle Enterprise Manager Cloud Control provides an unified user interface for creating and managing Oracle Data Redaction policies.įirst, you should create sensitive column types and formats if necessary, and then create the Oracle Data Redaction policy afterward. About Using Oracle Data Redaction in Oracle Enterprise Manager.

Oracle data redaction example