User Guide

Back Next

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: