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. XML Functions Reference
  9. Glossary

Column Alias \(alias)

Column Alias \(alias)

Use the column alias,
\(alias)
, for columns in multiple tables to prevent ambiguity.

Using \(alias) Example

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
to
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)||'**'