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

Column Level Masking

Column Level Masking

Column level masking prevents users from seeing data contained in a specific column and table.
In this example, the masking function shows the
sal
column in the
emp
table for employees that do not have the name King. To apply column level security, add the following masking function to the stored procedure in the database:
create or replace function mask_sal(sal in number, name in varchar) return integer as begin if name = 'KING' then return -1; end if; return sal; end;
Next, create a security rule masking function which causes the Rule Engine to mask select statements containing the
emp
table and
sal
column by using the
mask_sal(\(col). \(alias)ename)
masking function. Specify the Table name as
emp
, the Column Name as
sal
, and the Masking Function as
mask_sal(\(col). \(alias)ename)
.