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. Stored Procedure Result Set Masking
  9. Integration with Informatica Products
  10. Appendix A: XML Functions Reference
  11. Appendix B: Glossary

User Guide

User Guide

Using a Fully Qualified Table Name in Mask Action

Using a Fully Qualified Table Name in Mask Action

You can use a fully qualified table name in the Table Name field of a Mask action.
The following table shows the regular expression to use based on the database and the value in the Table Name column.
If Database is...
And Table Name Contains...
Use this format for the Regular Expression
Oracle
schemaName.tableName
(\")?<SchemaName>(\")?(\s)*(\.)(\s)*(\")?<TableName>(\")?(\s)*
schemaName.tableName with DBlink
(\")?<SchemaName>(\")?(\s)*(\.)(\s)*(\")?<TableName>(\")?(\s)*(\@)(\s)*(\")?<DBLink>(\")?(\s)*
tableName with DBlink
(\")?<TableName>(\")?(\s)*(\@)(\s)*(\")?<DBLink>(\")?(\s)*
Microsoft SQL Server
schemaName.tableName
(\")?<SchemaName>(\")?(\s)*(\.)(\s)*(\")?<TableName>(\")?(\s)*
If the object in the user query is enclosed by square brackets as in [schemaName].[tablename], use the following format:
(\[)?<SchemaName>(\])?(\s)*(\.)(\s)*(\[)?<TableName>(\])?(\s)*
Database.schemaName.tableName
(\")?< Database Name>(\")?(\s)*(\.) (\")?<SchemaName>(\")?(\s)*(\.)(\s)*(\")?<TableName>(\")?(\s)*
LinkedServer.Database.schemaName.tableName
(\")?< LinkedServer Name>(\")?(\s)*(\.) (\")?< Database Name>(\")?(\s)*(\.) (\")?<SchemaName>(\")?(\s)*(\.)(\s)*(\")?<TableName>(\")?(\s)*
Teradata
schemaName.tableName
(\")?<SchemaName>(\")?(\s)*(\.)(\s)*(\")?<TableName>(\")?(\s)*
Hive
schemaName.tableName
(\")?<SchemaName>(\")?(\s)*(\.)(\s)*(\")?<TableName>(\")?(\s)*
If the object in the user query is enclosed by a back quote as in 'schemaName'.'tablename' use the following format:
(\`)?<SchemaName>(\`)?(\s)*(\.)(\s)*(\`)?<TableName>(\`)?(\s)*
When the statement contains the same table name from different schema names, use the following Mask action rules:
When all references are fully qualified.
Example:
select da.first_name,du.first_name from ddmadmin.employee da, ddmuser.employee du
Mask action rule for the
Table Name
field:
Enter a fully qualified table name for each table candidate you want to mask.
When all references from non-current schemas are fully qualified, but the reference to the current schema is not fully qualified.
Example where the current schema is
ddmuser
:
select da.first_name,du.first_name from ddmadmin.employee da, employee du
Mask action rules for the
Table Name
field:
  • Enter a fully qualified table name for each table with a qualified table name in the statement.
  • Enter a schema for tables that do not have a fully qualified name in the statement.
  • Define the tables with a fully qualified name first. Then define the tables that do not have a fully qualified name.
The following image shows the recommended Mask action rules: