User Guide

Back Next

Column Alias \(alias)

Use the column alias,

\(alias)

, for columns in multiple tables to prevent ambiguity.

You want to mask a column,

deptno

, in the

emp

and

dept

tables. Use the column alias,

\(alias)

, with the masking function

substr(deptno, 1,2)||'**'

The masking function

mask_function(\(alias)deptno)

changes

select e.deptno, d.deptno from emp e, dept d

select substr("E".deptno,1,2)||'**' "DEPTNO" , substr("D".deptno,1,2)||'**' "DEPTNO" from "EMP" "E" , "DEPT" "D"

Create a rule that searches for tables with the column name

deptno

. When a match occurs, the Rule Engine applies the masking function to replace the data in the

deptno

column.

In the security rule, use the with the Mask rule action. The table name is

, the column name is

deptno

, and the masking function is

substr(deptno, 1,2)||'**'

Watch

Comments

0 COMMENTS

We’d like to hear from you! Log in to comment.