• Redacting Data in SQL Developer Data Modeler 4.0

    In this tutorial, you learn how to create data masks and data masking templates using SQL Developer Data Modeler 4.0 (Data Modeler).

    Duration: 20 minutes

    This content is intended for the following job role(s): Data Modeler, Database Designer, Application Developer

    Release Date: 23-OCT-2013

Reviews (3)

  • 9.1 years ago
    It is a great tutorial, Thanks a ton. But I guess something is missing. I have done everything as given in tutorial but how and when it will reflect in the table data. I have tried using Synchronize Data Dictionary. But the data wasn't masked. Could you please clear this.
    • 10.3 years ago
      Masking step 6 described the function_parameters as *,1,6. This is not acceptable as SALARY is numeric and only MASKCHAR that is valid is 0-9. Using * gives the following error... RA-28074: The "REDACT_PARTIAL_MASKCHAR" field of the redaction parameters is not valid. ORA-06512: at "SYS.DBMS_REDACT_INT", line 3 ORA-06512: at "SYS.DBMS_REDACT", line 40 ORA-06512: at line 2 Using 9,1,6 as function_parameter worked well.
      • pete.dehaan
        10.3 years ago
        Thank you for your valuable comment! I will examine the step and fix as required. This OBE will be tested soon against a new release candidate. So, please check back next week for the updated version. Regards, Pete
    • 10.3 years ago
      • pete.dehaan
        10.3 years ago
        Thanks! Glad you liked it.