Dynamic Data Masking Default Masking Functionality

Back Next

Use Case #4: SQL blocks that contain the EXECUTE AS command

Use case #4 contains an example of a scenario with SQL blocks that contain the EXECUTE AS command.

Example statement:


select * from employee 
use zdb 
execute as user = 'U21'
select * from emp 
revert
execute as user = 'U200' 
select * from emp1 
revert

The following table describes the example masking scenarios:

Keep Original Number of Rows	Old Masking Statement Modification	New Masking Statement Modification	Masking Action Functionality
N or Y	select employee . "EMPLOYEE_ID" , substring("EMPLOYEE"."LAST_NA ME",1,2)+'zzz' "LAST_NAME" , substring("EMPLOYEE"."FIRST_NA ME",1,2)+'zzz' "FIRST_NAME" , substring("EMPLOYEE"."MIDDLE_N AME",1,2)+'zzz' "MIDDLE_NAME" , employee . "JOB_ID" , employee . "MANAGER_ID" , employee . "HIREDATE" , employee . "SALARY" , employee . "COMM" , employee . "DEPARTMENT_ID" from employee use zdb execute as user = 'U21' select emp . "EMPNO" , substring(emp . "ENAME",1,2)+'zzz' "ENAME" , emp . "JOB" ,emp . "MGR" , emp . "HIREDATE" , emp. "SAL" , emp . "COMM" , emp . "DEPTNO" from emp revert execute as user = 'U200' select emp1 . "CEID" , substring(emp1 . "CNAME" ,1,2) + 'zzz' "CNAME" from emp1 revert	select employee . "EMPLOYEE_ID" , substring("EMPLOYEE"."LAST_ NAME",1,2)+'zzz' "LAST_NAME" , substring("EMPLOYEE"."FIRST_NAME",1,2)+'zzz' "FIRST_NAME" , substring("EMPLOYEE"."MIDDL E_NAME",1,2)+'zzz'"MIDDLE_NAME" , employee . "JOB_ID" , employee . "MANAGER_ID" , employee . "HIREDATE" , employee . "SALARY" , employee . "COMM" , employee . "DEPARTMENT_ID" fromemployee use zdb execute as user = 'U21' select emp . "EMPNO" , substring(emp . "ENAME" ,1,2)+'zzz' "ENAME" , emp . "JOB" , emp . "MGR" , emp . "HIREDATE" , emp. "SAL" , emp . "COMM" , emp . "DEPTNO" from emp revert execute as user = 'U200' select emp1 . "CEID" , substring(emp1 . "CNAME" ,1,2) + 'zzz' "CNAME" from emp1 revert	Original Number of Rows check box is not relevant.

Rename Saved Search

Table of Contents

Dynamic Data Masking Default Masking Functionality

Dynamic Data Masking Default Masking Functionality

Use Case #4: SQL blocks that contain the EXECUTE AS command

Use Case #4: SQL blocks that contain the EXECUTE AS command