Dynamic Data Masking Default Masking Functionality

Back Next

General Use Case #1: SQL statement with column list as asterisk (*) (implicit column list)

Use case #1 provides an example for a SQL statement that contains an asterisk (*). In this scenario the original Number of Rows check box is not relevant.

For both the old and new default masking functionality, Dynamic Data Masking expands the SQL statement to replace the asterisk with the list of the column names and then applies masking.

Example statement:

SELECT * from EMPLOYEES

The following table describes the example masking scenarios:

Keep Original Number of Rows	Old Masking Statement Modification	New Masking Statement Modification
N or Y	SELECT "EMPLOYEES" . "EMPLOYEE_ID" , substr("EMPLOYEES"."FIRST_NAME", 1,2) "FIRST_NAME" , substr("EMPLOYEES"."LAST_NAME", 1,2)\|\|'zzzz' "LAST_NAME" , "EMPLOYEES" . "EMAIL" , "EMPLOYEES" . "PHONE_NUMBER" , "EMPLOYEES" . "HIRE_DATE" , "EMPLOYEES" . "JOB_ID" , "EMPLOYEES" . "SALARY" , "EMPLOYEES" . "COMMISSION_PCT" , "EMPLOYEES" . "MANAGER_ID" , "EMPLOYEES" . "DEPARTMENT_ID" from EMPLOYEES	SELECT EMPLOYEES . "EMPLOYEE_ID" ,substr(EMPLOYEES . "FIRST_NAME" ,1,2) "FIRST_NAME" ,substr(EMPLOYEES . "LAST_NAME" ,1,2)\|\|'zzzz' "LAST_NAME" , EMPLOYEES . "EMAIL" , EMPLOYEES . "PHONE_NUMBER" , EMPLOYEES . "HIRE_DATE" , EMPLOYEES . "JOB_ID" , EMPLOYEES . "SALARY" , EMPLOYEES . "COMMISSION_PCT", EMPLOYEES . "MANAGER_ID" , EMPLOYEES . "DEPARTMENT_ID" from EMPLOYEES

The following table describes the example masking scenarios when the Dynamic Data Masking symbol AUTH_QUOTED_IDENTIFIER is set to OFF. This applies for the new masking functionality only.

Keep Original Number of Rows	Old Masking Statement Modification	New Masking Statement Modification
N or Y	SELECT "EMPLOYEES" . "EMPLOYEE_ID" , substr("EMPLOYEES"."FIRST_NAME", 1,2) "FIRST_NAME" , substr("EMPLOYEES"."LAST_NAME", 1,2)\|\|'zzzz' "LAST_NAME" , "EMPLOYEES" . "EMAIL" , "EMPLOYEES" . "PHONE_NUMBER" , "EMPLOYEES" . "HIRE_DATE" , "EMPLOYEES" . "JOB_ID" , "EMPLOYEES" . "SALARY" , "EMPLOYEES" . "COMMISSION_PCT" , "EMPLOYEES" . "MANAGER_ID" , "EMPLOYEES" . "DEPARTMENT_ID"from EMPLOYEES	SELECT EMPLOYEES . EMPLOYEE_ID , substr(EMPLOYEES . FIRST_NAME,1,2) FIRST_NAME , substr(EMPLOYEES . LAST_NAME,1,2)\|\|'zzzz' LAST_NAME , EMPLOYEES . EMAIL , EMPLOYEES. PHONE_NUMBER , EMPLOYEES . HIRE_DATE , EMPLOYEES . JOB_ID, EMPLOYEES . SALARY , EMPLOYEES . COMMISSION_PCT , EMPLOYEES . MANAGER_ID , EMPLOYEES . DEPARTMENT_IDfrom EMPLOYEES

Rename Saved Search

Table of Contents

Dynamic Data Masking Default Masking Functionality

Dynamic Data Masking Default Masking Functionality

General Use Case #1: SQL statement with column list as asterisk (*) (implicit column list)

General Use Case #1: SQL statement with column list as asterisk (*) (implicit column list)