Table of Contents


  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

Column Alias \(col)

Column Alias \(col)

Use the column alias,
, to mask columns with similar names.
When you use the column alias, the Rule Engine rewrites each identified column name with the respective name of the column. For example, the Rule Engine rewrites
select credit from customer
select mask_function(credit) from customer

Using the Column Alias Example

For example, you want to mask credit card numbers. Use the column alias to mask columns that start with
Create a security rule that uses the Mask action and searches all tables for the column name
. Define the table name as
, the column name as
, and the masking function as
. If the Rule Engine matches the column name, it rewrites the statement as