User Guide

9.8.0
- 9.9.4
- 9.9.3
- 9.9.2
- 9.9.1
- 9.9
- 9.8.4
- 9.8.3
- 9.8.2
- 9.8.1

Back Next

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)