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

Session Changing Commands

Session Changing Commands

You can use session changing commands within a SQL block for Microsoft SQL Server and Sybase databases.
In previous versions, Dynamic Data Masking handled database session changing commands through special rules. In these rules the session changing command was identified using a regular expression match. Then Dynamic Data Masking created the appropriate symbol to handle the command. However, when a session changing command was inside a SQL block, the command was ignored.
Dynamic Data Masking can now extract the session changing info from the command. Dynamic Data Masking then rewrites the command appropriately to extract the correct column metadata from the table.