nobody Have a Question? Help Login
  • Home
  • Content Details

Redacting Data in SQL Developer Data Modeler 4.0

3 user(s) recommend this content
  • In this tutorial, you learn how to create data masks and data masking templates using SQL Developer Data Modeler 4.0 (Data Modeler).

    • This content is intended for the following job role(s): Application Developer , Data Modeler , Database Designer
  • 23-OCT-2013
  • 20 minutes

Please Log In to Bookmark this OBE

Bookmarked 10 times

3 user(s) recommend this content

Hide/Show Reviews

bhaskarunichiranjeevi 1.3 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.
  • Login to add a reply
sudhakar 2.6 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.
  • 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 pete.dehaan 30-Oct-13
  • Login to add a reply
ganwj_28 2.6 years ago
  • Thanks! Glad you liked it. pete.dehaan 30-Oct-13
  • Login to add a reply

Hide/Show Related OU Courses

Hide/Show Additional Resources