User Guide

9.9.2
- 9.9.4
- 9.9.3
- 9.9.1
- 9.9
- 9.8.4
- 9.8.3
- 9.8.2
- 9.8.1
- 9.8.0

Back Next

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

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)),'')

Rename Saved Search

Table of Contents

User Guide

User Guide

Column Alias \(col)

Column Alias \(col)

Using the Column Alias Example