Search

Dynamic Data Masking Default Masking Functionality

Dynamic Data Masking Default Masking Functionality

Back Next

General Use Cases

General Use Cases

This H2L article contains descriptions of common use cases that demonstrate the old and new functionalities.

The following table summarizes the use cases:

#	Use Case	Masking Functionality
1	SQL statement with the column list as asterisk (*) (implicit column list).	Both the old and new masking approaches are applicable. For more details, see section Use Case 1.
2	SQL statement with an explicit column list that does not contain the WHERE, GROUP BY, HAVING, or ORDER BY clauses.	Both the old and new masking approaches are applicable. For more details, see section Use Case 2.
3	SQL statement with an explicit column list containing the WHERE, GROUP BY, HAVING, or ORDER BY clauses	Both the old and new masking approaches are applicable. For more details, see section Use Case 3.
4	SQL statement with an explicit column list containing the WHERE, GROUP BY, HAVING, or ORDER BY clauses together with UNION.	Both the old and new masking approaches are applicable. For "Keep Original Number of Rows"= Y only. For more details, see section Use Case 4.
5	SQL statement contains a subquery.	The new masking approach is applicable. For more details, see section Use Case 5.
6	SQL statement contains a subquery with the UNION operation.	The new masking approach is applicable. For more details, see section Use Case 6.
7	SQL statement contains a subquery containing GROUP BY, HAVING, and ORDER BY clauses.	The new masking approach is applicable. For more details, see section Use Case 7.
8	SQL statement contains a DISTINCT keyword.	The new masking approach is applicable. For more details, see section Use Case 8.
9	SQL statements contains a subquery without an alias.	The new masking approach is applicable. For more details, see section Use Case 9.
10	SQL statements where the candidate column is part of an expression without a column alias.	The new masking approach is applicable. For more details, see section Use Case 10.
11	SQL statement contains a WITH clause.	The new masking approach is applicable. For more details, see section Use Case 11.

Dynamic Data Masking Default Masking Functionality

Watch

Comments

0 COMMENTS

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