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. Appendix A: XML Functions Reference
  11. Appendix B: Glossary

Column Alias \(col)

Column Alias \(col)

Use the column alias,
\(col)
, to mask columns with similar names.
When you use the column alias, the Rule Engine rewrites each identified column name with the respective name of the column. For example, the Rule Engine rewrites
select credit from customer
to
select mask_function(credit) from customer
.

Using the Column Alias Example

For example, you want to mask credit card numbers. Use the column alias to mask columns that start with
credit.*
.
Create a security rule that uses the Mask action and searches all tables for the column name
credit.*
. Define the table name as
.*
, the column name as
CREDIT.*
, and the masking function as
nvl2\(col),('****-****-****-'||substr(CREDIT_CARD,length(trim(CREDIT_CARD))-3)),'')
. If the Rule Engine matches the column name, it rewrites the statement as
nvl2\(col),('****-****-****-'||substr(CREDIT_CARD,length(trim(CREDIT_CARD))-3)),'')
.

0 COMMENTS

We’d like to hear from you!