Dynamic Data Masking Default Masking Functionality

Back Next

Use Case #1: SQL batch (several SQL statements or commands) that do not contain set statements or the USE <Database> command

Use case #1 provides an example of a scenario with SQL batch (several SQL statements or commands) that do not contain set statements or the USE <Database> command.

Example statement:


EXECUTE GetTaskEvents2 'ALFKI',12209 
select * from EMPLOYEES; 
select * from customers where country ='Mexico' 
DECLARE @ret nvarchar(15); 
EXEC @ret = dbo.ufnGetInventoryStock @EMPID = 201

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	EXECUTE GetTaskEvents2 'ALFKI' , 12209 select "EMPLOYEES" . "EMPID" , substring("EMPLOYEES"."EMPNAM E",1,2)+'zzz' "EMPNAME" , "EMPLOYEES" . "SAL" from EMPLOYEES ; select * from customers where country = 'Mexico' DECLARE @ret nvarchar ( 15 ) ; EXEC @ret = dbo . ufnGetInventoryStock @EMPID = 201	EXECUTE GetTaskEvents2 'ALFKI' , 12209 select "EMPLOYEES" . "EMPID" ,substring("EMPLOYEES"."EMP NAME",1,2)+'zzz' "EMPNAME" , "EMPLOYEES" . "SAL" from EMPLOYEES ; select * from customers where country = 'Mexico' DECLARE @ret nvarchar ( 15 ) ; EXEC @ret = dbo . ufnGetInventoryStock @EMPID = 201	Transact SQL commands are ignored for masking; however, statements are masked.

Rename Saved Search

Table of Contents

Dynamic Data Masking Default Masking Functionality

Dynamic Data Masking Default Masking Functionality

Use Case #1: SQL batch (several SQL statements or commands) that do not contain set statements or the USE <Database> command

Use Case #1: SQL batch (several SQL statements or commands) that do not contain set statements or the USE <Database> command