Table of Contents

Search

  1. Preface
  2. Introduction to Dynamic Data Masking
  3. Rules
  4. Connection Rules
  5. Security Rules
  6. Security Rule Set Simulator
  7. Masking Functions
  8. Stored Procedure Result Set Masking
  9. Integration with Informatica Products
  10. XML Functions Reference
  11. Glossary

Scrambling Functions

Scrambling Functions

A scrambling function is a masking technique that rearranges values in the requested data. Scrambling functions use Oracle database syntax and are created by using the security rule Mask action.
The following table describes examples of scrambling functions.
Scrambling Function
Description
translate(reverse(\(col)), '1234567890', '97865301')
Scrambles the locations of the digits.
max(\(col)) over(order by empno rows between 1 and preceding and 1 following)
Provides list scrambling. The Rule Engine replaces the name with the letter value of the preceding and subsequent records.
nvl( lead(ename) over (order by ename), first_value(ename) over ( order by ename)
Offsets the address by a single row. If the value is null, the Rule Engine assigns the
first_value
of
ename
found in the
emp
table after sorting by
ename
.